I’m creating a BAQ to show PO history and part of that is including details from the header and line. When I link these two tables together it’s causing the PO lines to replicate and show up multiple times throughout the report. Is there a way to pull in information from both tables and not have the PO lines replicate?
Are you seeing a line form one order showing up under another order? Like line from Order 101 showing up on a row for order 102.
If so, that means you are missing some relationship.
If you linked in the OrderRel table, then you are going to get a row fro each release too.
For example, Order 101 has 1 line with 2 release, and Order 102 has 3 lines with 3 releases each.
You should see
OrdNum OrdLine OrdRel
101 1 1
101 1 2
102 1 1
102 1 2
102 1 3
102 2 1
102 2 2
102 2 3
102 3 1
102 3 2
102 3 3
Even though you only want 4 rows for the 4 lines of the two orders.
Check out this thread to get multiple row info into one row.
1 Like