Calculation in Forms based on another field

D

Dates

Hi,

I'm building a form ontop of a table. I have three fields
1. Link #
2. Gain/Loss
3. Total Gain/Loss.

For Example
Link # 1 Gain/Loss: $5.00 Total Gain/Loss: $1.00
Link #1 Gain/Loss: $-4.00 Total Gain/Loss: $1.00

I have built a calculation into the Gain/Loss. If I change another field
within the form, the Gain/Loss will change. What I'm having problems with
is, how do I get the Total Gain/Loss to change if the Gain/Loss changes per
that Link#?

Thanks in advance
Dates
 
Top