"Drilling" through relationship

[tobbesfilemaker]

Hey, I have 4 tables, Contacts, Products, Lineitem, Orders. 

 

I have a relationship that looks like this "contacts-order-lineitem-products".. so I can see the products ordered by the contacts. But I also want to see How many of the products they have ordered. Like a summary that shows how many of the products they have bought, So when I open a customer post I want to see what product they order the most. And then sort the portal by that field, So the first post in the portal shows what they have bought the most.

I would really appreciate help!

[bcooney]

Why wouldn't a portal on the Contacts form to LineItems, sorted by Qty_Ordered desc not work?

[tobbesfilemaker]

If I show the portal lineitems then It shows the same products multiple times, doesnt it? I want it instead to show the products once and a field that shows how many of this products has been ordered.

[bcooney]

I see, of course. afaik, you'll need to create a subsummary report based on the OrderLineItems. You may also wish to include a date range search in this routine.

[tobbesfilemaker]

bcooney, dont really see what u mean, can u do a "mini" file and show how ur thinking there? I would really appreciate it.

[bcooney]