A form to allow records to be added to existing entities

[LukeJ Innov]

Hello,



I have a large database with many tables etc. But for the sake of this question I will only use a small example.
I have two tables the first of which is 'Company' the Second is 'Company Contacts' linked by a primary key on the 'Company' table called 'Company ID'.
I would like to know how I would create a form that would allow me to add a contact to a previously existing 'Company' without having to manually write the primary key, for example selecting a company from a drop down box, then the primary key for the new contact would update and show correctly.

Regards

Luke.J

[Beetle]

Just to clarify, given a table structure like the following;

tblCompany
CompanyID (PK)
CompanyName

tblContacts
ContactID (PK)
CompanyID (FK to tblCompanies)
ContactName

You would then use a main form / sub form set up and the Master Child link property of the Subform Control (the Subform Control is the "window" that contains the sub form) handles the insertion of the foreign key value in the child table when new records are added in the sub form

[LukeJ Innov]

Hi,

Yes the table structure is like that.
Now its fine using a subform, but can you have more than one subform sitting on a main form? The wizard only lets you properly create one subform.
And I don't like using wizards anyway.

No need I figured it out, thanks for your help!!
Thanks