Use relationships

Create relationships with the Relationships Pane

Your browser does not support video.

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.

    Creating a relationship using the Relationships Pane
  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 Save .

Want more?

Create, edit or delete a relationship

Need more help?

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?