Create a table from an existing

[#1]

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

[#2]

Hello all,

this is ment as an question, not an discussion.

Håkan