Reference 2 Tables

[Maxwell]

Im trying to create a form using 2 Tables.
I go to wizard and pick both tables and nothing comes up
when I run the form.

If i pull just 1 table it works fine but if I pull 2
nothing happens.

Please advise

 

[Cheryl Fischer]

Maxwell,

You can use fields from two tables as the RecordSource of a form when those
two tables are used in a query - you would then select the query as the
form's record source.

Or, if you are trying to display records that are in a Parent-Child
relationship such as Customers (Parent) and Orders (child), you can make the
Customers table the RecordSource of your main form. Then, create a sub-form
using Orders as its RecordSource. Insert the sub-form as a control on the
Main form.