I am trying to bring in both Ship Date and Tracking number from ShipHead to a BAQ currently containing: OrderDtl, Customer, RMADtl, RMARcpt and RMAHead.
The point of the BAQ to is show RMA Line information.
I can’t find a way to connect them without getting extra lines.
I tried doing an inner subquery containing InvcDtl and ShipHead and marked all fields as ‘Group By’ but that didn’t seem to help.
I was trying to use InvcDtl for the RMANum to connect to RMAHead in main query.
If there is a better way to connect ShipHead to the above tables then let me know please.
When building a BAQ go one table at a time ensuring you’re not getting duplicates. Then you’ll know which table is causing the duplicate. There is a protentional of multiple shipments to a OrderDtl so you could be seeing a situation with multiple lines because of multiple packs.