I have created a report from query, the main table has the main data and the next table have the documents
the screen should look like this:
ID Co Inv Name section date amount Supplier Document Amount Supplier Date 1 100025 alan sec1 5/5/2016 500 LPO 10000 4/5/2016 EVRF Inv 500 4/8/2016
however, this is how it appears
ID CoInv Name section date amount Supplier Document Amount Supplier Date 1 100025 alan sec1 5/5/2016 500 LPO 10000 4/5/2016 sec1 5/5/2016 EVRF sec1 5/5/2016 Inv 500 4/8/2016
How can I make the section and date not repeat. the supplier document, amount and supplier date comes from another table, they are connected to CoInv which is unique
please help.
Thank you.
Trident