How to Create One to Many Relationship in Microsoft Access

Guide

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.