#### Look up all of one, then all of others (A to B, A to C)

For each record in the Customer table, this option looks for all the matching records in the Credit table (Table B) and then looks for all the matching records in the Orders table (Table C). Then it repeats the process with the next record in the Customer table, and continues with the rest of the records.

Customer Table | Credit Table | Orders Table
--- | --- | ---
Customer Name | Amount | Order Amount
Cyclists Incorporated | ($1088.56) |
Cyclists Incorporated | ($1260.12) |
Cyclists Incorporated |  | $1529.70
Cyclists Incorporated |  | $23.50
CyclePath Corp. | ($1958.03) |
CyclePath Corp. | ($1076.43) |
CyclePath Corp. | ($75.04) |
CyclePath Corp. |  | $49.50
CyclePath Corp. |  | $1702.60
The Great Bike Shop | ($138.98) |
The Great Bike Shop |  | $3269.70
The Great Bike Shop |  | $5219.55
The Great Bike Shop |  | $1538.20

Note: If you want Table C data (the Orders table in this example) to appear in the report before Table B data (Credit table), you need to change the links so that the A to C link comes first, followed by the A to B link. You do this in the Visual Linking Expert. To change the order of the links, delete the existing links and set up new links in the desired order.

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