FoxPro 9 Multiple Detail Band Issue

Report has 3 tables: (Customer, Orders1, Orders2)

- Customers Main Table (Group 1- Customer.pkey)

- Detail Band 1: Show all orders placed by customer (Group 2 order.pkey)

Sample Report appears like this:

Customer 1

Order1Date1Apples2

Order2Date1Oranges3

Order3Date2Apples4

Order4Date2Oranges5

In the 2^nd Detail Band I would like to show results like:

Total Apples Ordered: 6

TotalOranges Ordered: 8

Please Note that I need the first detail band to use table Orders1 (relationship customer.pkey = orders1.fkey)

2^nd Detail Band needs to use table Orders2 (relationship customer.pkey = orders2.fkey)

Is this possible?

[3413 byte] By [FoxProg9] at [2008-2-16]