2 of 2 people found this helpful
no portal needed
the second sub-summary part should be by customer, not by item.
make sure your layout is sorted by item, then by customer.
Not needed to fix your problem, but you should be using a unique key (such as a auto-incrementing serial number) as your relationship key.
Do you only ever have 1 item per order? If not, you'll need another table.
Thanks Jason - I got most of it to work. Yes for this simplified example there is only one item in an order (I'm creating something completely different but thought this was the best way to explain).
Only issue I have now is to display the Qty field for each customer in the second sub-summary. Creating a summary field that is a total of OrderCount gives me the total number of orders for that customer, not the total orders of that item for that customer. Ideas on how I calculate this value?
The summary should be the total of the qty field. Which I would think you already have created because it's in your first sub-summary(?)
Yes got it. I forgot I could assign the field to the other table. All working now. Thanks