1 Reply Latest reply: Sep 20, 2011 10:07 AM by Håkan Fogelin RSS

    Create a table from an existing

    Håkan Fogelin

      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