#### Creating a one-to-many linking relationship

1. To get started, create a report using the sample data, `Xtreme.mdb` located in the `File Data Sources` folder of the Data Explorer dialog box.
2. Highlight the `Credit` table and click `Add`.
3. Repeat the previous step for both the `Customer` and `Orders` tables.
4. When all three tables have been added, click `Close` on the Data Explorer dialog box.

   The Visual Linking Expert appears.

5. Link the `Customer Credit ID` field in the `Credit` table to the `Customer ID` field in each of the other two tables.

   Note: A different linking configuration occurs if you click Smart Link and this tutorial will not work properly.

6. Select one of the links in the Visual Linking Expert and click `Options`.
7. Click `Look up all of one, then all of others` in the `When linking to two files from this file` section of the Link Options dialog box.

   This option establishes an A to B, A to C link.

8. Click `OK` to return to the Visual Linking Expert.

   The option you selected affects all links.

9. Click `OK` to close the Visual Linking Expert.

You have now established an A to B, A to C relationship among the three tables. Now you'll use the tables to create a report with a running total.

See Creating a running total in a one-to-many linking relationship.

Seagate Software, Inc. http://www.seagatesoftware.com Please send comments to: techpubs@seagatesoftware.com