Subforms & relationships

[Mike]

Hi. I am relatively new to subforms ...

I would like to create a form that has two subforms. I
understand how to create this using the Form Wizard, but I
am not sure how to specify the table relationships.

For instance, with the main table, I have the auto-
generated ID. How do I tie this to the records in the two
other tables?

Any suggestions will be appreciated!

Thanks,
Mike.

 

[Dave Ruhl]

The tables used in the subforms should have a field
(foreign key) that links them to the table used on your
main form. The subforms would then link to the main form
using that key field.

For example, say your main table, displayed on the main
form, is Customers (with a key field CustID). Your two
subforms could show Invoices (with a foreign key field
CustID) and Orders (also with a foreign key field CustID).