Use Master Table Field Value to build Details Table Field Value

[#1]

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?

Thanks in advance

Panayotis