Tables

Hi Lorraine,

If you want to select more than one table in a query design, right click into the upper blank part of the query and select and add the table, then select and add another. Then you can select what fields you want from each table by dragging them into the grid. You can even mix them up so that you drag in fields alternating across the two tables. This will work so long as the tables are related in someway which in most cases they will be. You can see if they are related or not because a join line should appear between the tables.

If you want more than one table to show in the same form, how you do this depends on how the tables are related. If there is a one-to-many relationship between two tables you can create form based on the 'ones' table and then insert a subform using the subform button in design view, then selecting the 'many' table for the subform. Go to form view to check it works, and back to design view to re-size as required to fit the view of data.

Is this what you was looking for?

Mark