This is a problem I have struggled with the last time, I belive
that you guys have a clever solution.
table1:
Load Ordernumber
resident Orders
where Pos='300';
the table Orders looks like this
Name Ordernumber Pos Pcs
Item1 100 100 1
Item4 100 105 1
Item5 100 106 1
Item1 100 200 1
Item4 100 205 1
Item5 100 206 1
Item2 100 300 1
Item1 200 100 1
Item4 200 105 1
Item5 200 106 1
Item1 200 200 1
Item4 200 205 1
Item5 200 206 1
Item2 200 300 1
Item1 300 100 1
Item1 300 200 1
Then I will search in table Orders with Ordernumber from table1 to
get this result
Name Ordernumber Pos Pcs
Item 1 100 100 1
Item 1 100 200 1
Item 2 100 300 1
Item 1 200 100 1
Item 1 200 200 1
Item 2 200 300 1
Item 1 300 100 1
Item 1 300 200 1
Item 2 300 300 1
To be able to create this Diagram
Diagram
Ordernumber Item Item Pcs Item2 Pcs Item1
100 Item2 Item1 1 2
200 Item2 Item1 1 2
300 Item2 Item1 1 2
kindly
Håkan
