To create a 1:1 relationship in Microsoft Access,the Indexed property of the foreign key column must be set to Yes (No Duplicates).

Name: To create a 1:1 relationship in Microsoft Access,the Indexed property of the foreign key column must be set to Yes (No Duplicates).
Brand: Quizplus
Rating: 4.9 (38 reviews)

Question

Quizplus · Accepted Answer

A 1:1 relationship in Microsoft Access requires a unique foreign key value for each record in the related table. This is achieved by setting the Indexed property of the foreign key column to Yes (No Duplicates).

To Create a 1:1 Relationship in Microsoft Access,the Indexed Property