# How to Create One to Many Relationship in Microsoft Access

> To create a one-to-many relationship in Microsoft Access, go to the Database Tools tab, click Relationships, and add your tables. Drag the EmployeeID field from Employees to Payrolls, check Enforce Referential Integrity in the Edit Relationships dialog box, click OK, and save.

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

## Steps

1. Go to the 'Database Tools' tab.
2. Click 'Relationships'.
3. Select the tables you want to add and click 'Add Selected Tables'.
4. Drag the 'EmployeeID' field from the 'Employees' table to the 'EmployeeID' field in the 'Payrolls' table.
5. In the 'Edit Relationships' dialog box, ensure Enforce Referential Integrity is checked.
6. Click 'OK' to create.
7. Click 'Save' in the Relationships window.