View Relationships Between Tables

When you add a lookup field, Microsoft Access creates a relationship between the two tables, making them part of a unified database. When tables are related, you can combine data from each table in queries, forms, and reports.

You can see the tables in your database and the relationships between them in the relationships window. To open this window, in the database window, click the Relationships button.

Relationships button

Each table is represented by a field list. The lines that connect field lists show the relationships between tables. To see a table in the relationships window, you have to add it. To add the Suppliers table, click Show Table (Relationships menu), select Suppliers, and then click Add.

For more information, see Use Your First Microsoft Access Database.

Next Steps