Creating a One-to-Many Relationship Complete the steps for creating a one-to-many relationship of two tables.
1. Open the database.
2. On the
tab in the Relationships group, click Relationships.
3. On the Relationship Tools Design tab in the
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 then click Close.
6. Click and drag the
from a table and drop it on the primary key of the other table.
7. In the
box, make sure the correct fields are being linked.
8. Click the Enforce Referential Integrity checkbox, and then click Create.
Ve