One Form Field to populate Fields in multiple tables

[sgp667]

I have a form where I need to input Invoices. First I need to input invoice number, this is primary key in table "Invoices".


That Invoice number also serves as a foreign key in table "Invoice Items", and those items will be inputted in the same form.

In other words what I need is a form that will create a record in "Invoices" and multiple records in "Invoice Items" with each record having Invoice# as one of the fields.

[Missinglinq]

You're describing a classic one-to-many relationship, here, and this is typically done by using a Main Form (based on the Invoice Table) and a Subform (based on the Invoice Items Table).

The Main Form will be in Single View, the Subform in Datasheet View.

After creating both Forms, go into Design View for the Main Form and add a Subform Control. When prompted by the Wizard, select the Invoice Items Form as the base for the Subform. If the Invoice Number Field is named the same in each Table, Access will automatically link the Main Form/Subform using this Field, and when you go into the Subform, the Invoice Number will automatically be populated.

Linq ;0)>