Question

Which of the following is NOT a step in creating a one-to-many relationship?

A) Make sure the two tables have a field in common.
B) Form the relationship in the Relationships window.
C) Populate the foreign key by adding data to the foreign key in the many side table.
D) Use the foreign key from the one side, and add it as a primary key in the many side table.

Answer 1

In order to create a one-to-many relationship between two tables in a database, you need to make sure they have a common field, form the relationship in the Relationships window, and populate the foreign key. The correct answer is to add the foreign key as a foreign key in the many side table.

Step-by-step explanation:

In order to create a one-to-many relationship between two tables in a database:

1. Make sure the two tables have a field in common.
2. Form the relationship in the Relationships window.
3. Populate the foreign key by adding data to the foreign key in the many side table.
4. Use the foreign key from the one side, and add it as a foreign key in the many side table.

Therefore, the correct answer is D) Use the foreign key from the one side, and add it as a primary key in the many side table.