0 Replies Latest reply: Mar 21, 2012 6:41 AM by Panayotis Matsinopoulos RSS

    Use Master Table Field Value to build Details Table Field Value

      Hi,

       

      I would appreciate any help on the following:

       

      * I have a Header table and a LineItems table, with the key connection between them is "HeaderGID".

       

      Example:

       

      Header:

       

      HeaderGID
      Multiplier
      1231
      124-1
      1250
      1261
      127-1
      1281

       

       

      LineItems:

       

      LineItemId
      HeaderGID
      Value
      112310
      212320
      312330
      412415
      512410
      612520
      712630
      812640
      912715
      1012750
      1112760
      1212810

       

       

      The point is that I want to add a column on LineItems with name "FinalValue" which will be the result of the multiplication of the "Value" by the "Multiplier". Hence, I want the final LineItems table to be as follows:

       

      LineItems (Final):


       

      LineItemIdHeaderGID
      Value
      FinalValue
      11231010
      21232020
      31233030
      412415-15
      512410-10
      6125200
      71263030
      81264040
      912715-15
      1012750-50
      1112760-60
      121281010


      Any help on how can I use the associated field values of Multiplier when I load the LineItems?

       

      Thanks in advance

      Panayotis