How to Create One to Many Relationship in Microsoft Access
- George Apostolov
- 05 Sep 2025
Guide
Go to the 'Database Tools' tab.
Click 'Relationships'.
Select the tables you want to add and click 'Add Selected Tables'.
Drag the 'EmployeeID' field from the 'Employees' table to the 'EmployeeID' field in the 'Payrolls' table.
In the 'Edit Relationships' dialog box, ensure Enforce Referential Integrity is checked.
Click 'OK' to create.
Click 'Save' in the Relationships window.
Create your first interactive demo in minutes
No credit card required • Start building today
