Topics Map > Office 365 > Access

Access - Create Relationships with the Relationships Pane

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 Relationshipspane.

  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 a relationship

Delete a relationship

Excel training

Outlook training

If you have any questions, come by the Help Desk at Hardman & Jacobs Undergraduate Learning Center Room 105, call 646-1840, or email us at help@nmsu.edu.




Keywords:access create relationship pane office 365 columns   Doc ID:79473
Owner:John B.Group:New Mexico State University
Created:2018-01-19 11:24 MDTUpdated:2018-05-24 08:36 MDT
Sites:New Mexico State University
Feedback:  0   0