• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Lesson 25. Working with Related Tables > Creating Multitable Queries

Creating Multitable Queries

Multitable queries are used for pulling information from more than one table at the same time. You can then use that information in reports, forms, or other queries, or you can simply view the information in a table-like query results window.

To create a multitable query, create a new query through Design view (refer to Lesson 21). In the Show Table dialog box, add more than one table before you click Close. You'll then have multiple tables to pull fields from. If the tables aren't already linked, create a temporary link between them by dragging a field from one table to its matching field in the other table, just as you did in the Relationships window in Lesson 10. Then proceed normally to finish the query, as you learned in Lesson 21.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint