If the answer to the question is "Purchased", then select "Adagio {Composite Tables 8.0C}" as the Module and "*SR Trans w Cust" or "SR Trans with Cust, Items" as the table. (You only need the table with the items if you want something like the item description on the View. It will be slower than using just the customer.)

Select the fields you want from the table. You'l probably want to filter out the Tax and Miscellaneous charge lines and use just the regular item lines from the file. ("T", "M" and "L" Line types respectively.)

I think this will be a little more staightforward that Brian's approach for a one-time lookup.

I'd recommend a slightly different approach if you only want to see what was ordered (but might not have been purchased), or you didn't have SalesAnalysis.
_________________________
Andrew Bates