Using more than one table

Mike Powell

Registered User.
Local time
Today, 21:06
Joined
Apr 18, 2001
Messages
21
I have set up 5 tables in the tables area. I want to create a tab form with three pages, and use various data from all tables. It will only let me use data from one table. I have relationships between one field across all the tables. HELP !!
 
Create a query and add the 5 tables to the query. Drag the fields you want on your form to the QBE grid. Then use the query as the Record Source for your form.
 

Users who are viewing this thread

Back
Top Bottom