Hi Steve,

I misinterpreted your post to mean that you needed separate Views into the AR and IC masters to get the customer names and item descriptions, presumably using GETLINKEDVALUE() function calls. Closer reading shows that probably wasn't what you meant.

However, there are lots of tables in Adagio that just contain the customer code or item number, so getting comfortable inserting the related information is a good skill.

Attached is a workspace on the SalesAnalysis Sample Data which demonstrates Brian's linking suggestion and how you would select the items purchased by one customer and sort them by date descending.