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.