add multiple entries agains each auto number

[Rahat]

Hi Dear,



I have attached file. I need to create the Customer database, for each company there are more than one contact persons, i need to add them all against each company and ID should change for the new company only.

Please help on this.

Thanks and regards

[June7]

Use form/subform arrangement.

[CJ_London]

you need a separate table for contacts to use in your subform

tblCompanies
CompanyPK autonumber
CompanyName text
CompanyAddress text
Webpage text or hyperlink


tblCompanyContacts
ContactPK autonumber
CompanyFK number - links to CompanyPK in tblCompanies
ContactName text
Position text
Phone text
Email text

[ArviLaanemets]

An example of form-subform setup: