One-to-one relationships
In a one-to-one relationship, one record in a table is associated with one and only one record in another table. For example, in a school database, each student has only one student ID, and each student ID is assigned to only one person.
A one-to-one relationship looks like this in the relationships graph:
In this example, the key field in each table, Student ID, is designed to contain unique values. In the Students table, the Student ID field is the primary key; in the Contact Info table, the Student ID field is a foreign key.
This relationship returns related records when the value in the Student ID field in the Contact Info table is the same as the Student ID field in the Students table.
