multiple lines per contact in the database[create sub tables etc]

[tariq nawaz]

i have an excel file with multiple contacts per vendor . like for vendor i have 3 contact one for logistics , one for operations and one for billing.


i want to import them in my access database but what is the easiest way to do that in a way that when i refer them from queries i can select the person and contact detail against that.
i am a novice to databases and trying to create small application .


Regards

A learner

[June7]

Have a column in the contacts table for the Category (logistics, operations, billing).

Data entry/edit should be form/subform arrangement.

For report could join Vendors and Contacts tables in RecordSource query. If you want only one category then use filter criteria under the Category field. Or instead of joining in query, use report/subreport arrangement.

The alternative is not to use child table for Contacts. If each Vendor will have no more than the 3 contacts then these could be additional fields in the Vendor table.

It is a balancing act between normalization and ease of data entry/output.