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
123
1
124
-1
125
0
126
1
127
-1
128
1
LineItems:
LineItemId
HeaderGID
Value
1
123
10
2
123
20
3
123
30
4
124
15
5
124
10
6
125
20
7
126
30
8
126
40
9
127
15
10
127
50
11
127
60
12
128
10
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):
LineItemId
HeaderGID
Value
FinalValue
1
123
10
10
2
123
20
20
3
123
30
30
4
124
15
-15
5
124
10
-10
6
125
20
0
7
126
30
30
8
126
40
40
9
127
15
-15
10
127
50
-50
11
127
60
-60
12
128
10
10
Any help on how can I use the associated field values of Multiplier when I load the LineItems?
