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?