How to Create One to Many Relationship in Microsoft Access
Here's how you can do it:
- 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.
This website uses cookies to ensure you get the best experience on our website. Learn More
Got it