selecting more than one table

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

Hi Lorraine,
Thank you for your post, welcome to the forum, I am a little bit confused by your question, do you mean selecting more than one table (if so for what reason) or do you mean selecting fields from more than one table. There are many occasions when we select more than one table, for example to include those table in the relationships window, to include them in a query, in these cases they will be displayed in the select table dialog box (little icon with a yellow cross) and can be selected for insertion or inclusion by using the CTRL key or the SHIFT key to select more than one at a time.
I hope that is the right answer, if not please come back with more information, otherwise please click the resolved link, regards Pete