#### Look up all the combinations of the two files

For each record in the Customer table, this option looks for a matching record in the Credit table, and then finds all the matching records in the Orders table. Once it finds all the matching records in the Orders table, it repeats the process with the next record in the Credit table, then the next, etc. When it finds matching Orders records for all the Credit records that match the first Customer record, it moves to the next Customer record and repeats the process.

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

Note: If you want the program to look up the first matching record in Table C (the Orders table in this example), and then find all matching records in Table B (Credit table), the reverse of the current process, you will need to change your 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 order you want.

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