I’ve created a universe, linking Purchase Order and Voucher Information. There are instances where more than one Voucher can be linked to a Purchase Order. This is causing the following issue when users are reporting against the data:
User would like to see quantity totals for each voucher, but only see the purchase order total once. In essence, the PO information is the header info, and the voucher info is the detail …
Any suggestions? The user needs to eventually sum on the PO quantities, and the duplicates would overstate the totals.
I hope this makes sence.
lcp 
(BOB member since 2004-06-10)
(BOB member since 2002-06-17)