Advanced Database – Create, modify, delete a one-to-many relationship
A one-to-many relationship links the primary key to a field in a second table that may have more than one records (row).
Click Tools – Relationships from the main window ribbon.
The Relation Design window opens. Click ‘Insert’ – Add Tables.
Add the ‘Mechanics’ table.
Create a one-to-many relationship between the Staff Number field in the ‘Jobs’ table to the Staff Number field in the ‘Mechanics’ table.
It automatically sets it as a one-to-many relationship, with 1 at the primary end and ‘n’ at the other.
This is because there is only one staff number per mechanic, but there are more than one job record for each staff number.
To modify the relationship, right click and select Edit.
To delete the relationship, right click and select Delete.