microsoft access 2002 training - 1 - 1 relationship

Paul

A One-To-One relationship can only be created between two tables that have the same Primary key.

eg.

A Table containing Employee Details like Name, Address, Home Phone No., with the EmpID as a Primary Key.

A second table containing Salary Details like Basic Salary, Bonus, Pension, with the EmpID also as a Primary Key.

When connecting these two tables through the EmpID it creates a One-To-One relationship.

Hope this helps.

Carlos