Create relationships with the Relationships Pane

Like the Lookup Wizard, the Relationships pane provides a quick way to create relationships between tables in your Access database. The differences between the two methods are:

  • To use the Relationships pane, your child table must have a foreign key with the same data type (or a compatible one) as a column in the parent table. The Lookup Wizard adds this data column to the child table.

  • The Relationships pane doesn’t create a lookup list.

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

Back to previous page Go to next page

Try it!

  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 .

Top of page

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!