135k views
1 vote
Use the drop-down menus to explain how to create a one-to-one relationship using the primary keys of two tables.

1. Open the database.
2. On the Database Tools tab, in the Relationships group, click
3. On the Relationship Tools Design tab, in the Relationships group, click
4. In the dialog box, click one of the tables to add, and click Add.
5. Click the other table to add, click Add, and click
6. Click and drag the primary key from a table, and drop it on the primary key of the other table.
7. In the Edit Relationships dialog box, make sure the correct fields are being linked.
8. Click the Enforce Referential Integrity checkbox, and click

User Moinkhan
by
5.2k points

2 Answers

4 votes

Answer:

Use the drop-down menus to explain how to create a one-to-one relationship using the primary keys of two tables.

1. Open the database.

2. On the Database Tools tab, in the Relationships group, click

✔ Relationships

.

3. On the Relationship Tools Design tab, in the Relationships group, click

✔ Show Table

.

4. In the dialog box, click one of the tables to add, and click Add.

5. Click the other table to add, click Add, and click

✔ Close

.

6. Click and drag the primary key from a table, and drop it on the primary key of the other table.

7. In the Edit Relationships dialog box, make sure the correct fields are being linked.

8. Click the Enforce Referential Integrity checkbox, and click

✔ Create

Explanation: Just did it and its correct

User Glennanthonyb
by
6.6k points
0 votes

Answer:relationships, show table, close, create

Explanation: just did it

User Pankaj Jangid
by
5.4k points