Show All

View existing relationships (MDB)

Note  The information in this topic applies only to a Microsoft Access database (.mdb).

1. Press F11 to switch to the Database window.
2. Click Relationships on the toolbar.
3. Do one of the following:

   View all the relationships defined in the database

   • Click Show All Relationships on the toolbar.

   View the relationships defined for a particular table

   • Click the table, and then click Show Direct Relationships on the toolbar.

   View only the relationships defined for one table without viewing the relationships defined for other tables

   1. Click Clear Layout on the toolbar to remove all tables from the Relationships window (this won't delete the tables or relationships; it just removes them from the Relationships window).

   2. To add the table back, click Show Table on the toolbar, double-click the table, and then click Close.

   3. Click Show Direct Relationships on the toolbar.