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