If you do not find a relationship between the two tables, create one by dragging a field from one of the tables to a field on the other table. On the Design tab, in the Show/Hide group, click Table Names.ĭouble-click each of the tables you want to show, and then click Close. If the tables are not visible in the Relationships window, you must add them. You can double-click a relationship line to see which fields in the tables are connected by the relationship. If the tables are visible in the Relationships window, check to see that a relationship has already been defined.Ī relationship appears as a line connecting the two tables on a common field. Identify the tables that should have a defined relationship.

On the Design tab, in the Relationships group, click All Relationships. On the Database Tools tab, in the Show/Hide group, click Relationships. Use the Query Wizard to build a query from a primary table and a related tableĮnsure that the tables have a defined relationship in the Relationships window. To get the employee names to appear in your query results, you need to include both tables in your query. You realize it would be more useful to view the employee name in the results, but the employee names are located in a different table. For example, suppose you have a list of employee IDs that appear in your query results. You may have cases in which a query that is based on one table gives you the information you need, but pulling data from another table would help to make the query results even clearer and more useful.

View all the records from two similar tables

Use data from a related table to enhance the information in your queryĬonnect the data in two tables by using their relationships with a third table This topic explores some scenarios where you pull data from more than one table, and demonstrates how you do it. But what if, as is more often the case, the data you need is spread out in more than one table? Fortunately, you can build a query that combines information from multiple sources. Sometimes, the process of building and using queries in Access is a simple matter of selecting fields from a table, perhaps applying some criteria, and then viewing the results. Access for Microsoft 365 Access 2021 Access 2019 Access 2016 Access 2013 Access 2010 Access 2007 More.

Query and replace aquamacs