Using the Relationships Window

To view and define relationships between tables:

1. Click the Relationships toolbar button.
2. Click the Primary Key field name in the Primary table.
3. Drag it to the related field name in the Secondary table.
4. Review the relationship in the Edit Relationships window.
5. Click the Create button.

Open the Relationships window by clicking the Relationships toolbar button. To create a new relationship, click the primary key field name in the primary table and drag to the related field name in the secondary table. The Edit Relationships window will automatically open. Review the relationship, and click the Create button.