Creating Relationships in Microsoft Access 2007

If this is the first relationship you've created in the current database, the Show Tables dialog box will appear, as shown in the image above.

One at a time, select each table that you'd like to include in the relationship and click the Add button. (Note: you can also use the Control key to select multiple tables.) Once you've added the last table, click the Close button to continue.