O'Reilly logo

Ten Minute Guide to Access 97 by Faithe Wempen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Creating a Relationship Between Tables

To create a relationship between tables, open the Relationships window and add relationships there. Follow these steps:

  1. In the database select Tools, Relationships.

  2. If you have not selected any tables yet, the Show Table dialog box (see Figure 25.1) appears automatically. If it doesn't, Open the Relationships menu and select Show Table or click the Show Table toolbar button.

    Figure 25.1. Add tables to your Relationships window using this dialog box.

  3. Click a table that you want to use for a relationship, then click the Add button.

  4. Repeat step 3 to select all the tables you want, then click Close. Each ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required