# How to Create Relationship in MS Access

> To create relationships in MS Access, open your database, navigate to the Database Tools tab, and click Relationships. Select and add your tables, drag the primary key from the parent to the child table, verify the fields, enforce referential integrity, and click Create before saving.

Canonical: https://livedemo.ai/tutorials/how-to-create-relationship-in-ms-access/
Updated: 2026-10-05
Interactive demo: https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a3a0fab56e05a00fe0f41/preview?step=1

## Steps

1. Open the database file where you want to create relationships between tables.
2. Go to the 'Database Tools' tab in the ribbon.
3. Click on 'Relationships'.
4. Select the tables you want to relate.
5. Click 'Add Selected Tables'.
6. Drag the primary key field from the parent table and drop it onto the corresponding field in the child table.
7. The 'Edit Relationships' dialog box appears. Verify the fields being related are correct.
8. Select 'Enforce Referential Integrity' to ensure that you cannot enter a value in the child table that doesn't exist in the parent table.
9. Click 'Create' to save the relationship.
10. Save the relationships by clicking 'Save'.