View Full Version : Using more than one table


Mike Powell
04-18-2001, 08:38 AM
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 !!

Jack Cowley
04-18-2001, 10:38 AM
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.