Video: Create relationships with the Relationships Pane

Try it!

The Relationships pane creates relationships between tables, but requires a compatible data type between the parent/child columns and doesn’t create a lookup list.

Create relationships with the Relationships pane

1. In any database with at least two tables or queries, select Database Tools > Relationships.

2. If the Relationships pane is blank, drag the tables from the Navigation pane to the Relationships pane.

3. Drag the primary key from the parent table to the top of the foreign key in the child table.

   

4. Select Enforce Referential Integrity.

5. Select Cascade Update Related Fields and Cascade Delete Related Records.

6. Select Create.

   You’ve added the relationship between the two tables, so now you see a line that shows the relationship type (one-to-one or one-to-many) and indicates which fields are related.

7. To save the relationship, select Save .

Want more?

Create, edit or delete a relationship