Database Wizard: Step 4 – Set Relationships

See Also

You can establish or change relationships between tables in your database.

To specify a relationship between tables in your database

1. In the Select table list box, highlight the table containing the field you want to use.
   
   
2. In the relationship list box, highlight the relationship statement you want to edit, and then click the Relationship… button.
   In the Relationships dialog box, click the radio button next to the description of the type of relationship you want to create.
   You can select the key field or create a new field by typing in the edit box.
   
   
3. Click OK

The Relationships dialog box returns you to Step 4 of the Wizard where the new or edited relationship is listed in the relationship list box.