Form for one to many 1

[tlove161]

I have a table that is the "one" side of the relationship. This table has a primary key (autonumber). I have a second table "many side" which is linked to the "one side" by the primary key.

I have created a form for the "one" table, but how do I enter records into the "many" table via the form. I need the primary key to be assigned to each record created in the "many" table.

Any guidence is appreciated.

 

[BobStubbs]

I would create a sub-form to display the 'many' table. If you let Access create the sub form with the Wizard feature turned on, it will guide you through how to identify the Primary Key field in the main table, and link this to the foreign key field in the sub table.

If you set the sub-form view to 'continuous forms' you should then be able to see one or more sub-records, linked to a given main record. As you scroll / move through the main records, Access will display the related sub records in the sub-form.

If the main form is already quite large, consider adding a tab control to the form. You could set up two tabs, and place the existing main form fields on the first tab. Then create the sub-form on the second tab, to give a neat result.

Bob Stubbs

 

[tlove161]

Bob

Thank you. The sub form now does what I need.