I have three tables that are linked as follows:

SOShipheader.shipperid, SOShipheader.invctot

SOShipline.shipperid, SOShipline.invtid, SOSHipline.qty, SOShipline.price

SOShipmisc.shipperid, SOShipmisc.miscid, SOShipmisc.charge

Here is what I want the report to look like:

S80709 150.00
abcpart 3 40.00
defpart 1 10.00
misca 20.00


S80710 30.00
defpart 1 20.00
miscb 10.00



I have group1 as soshipheader.shipperid

I have tried putting the soshipline information in details a and the soshipmisc information in details b. It lists all the soshipmisc information for each of the soshipline entries. The same thing happens if I put soshipheader information in group1, soshipline information in group2, and soshipmisc information in group3.

Does anyone have any suggestions?