Hi
Not sure if I can explain my problem clearly enough but here goes.
I have a row (the row is contained in a subform called "Item"), this row contains 4 numeric fields. These are called
"ProjectTotal"
"EstimatedCost"
"Reimbursment" (which is a needs to be a percentage) and
"Total"
The "Total" field needs to run a scipt which will calculate the "ProjectTotal" by the "Reimbursement" field (eg. $10,000 x 30%) and the "EstimatedCost" by the "Reimbursement" field.
The amount that appears in the "Total" field must be the lesser amount of the two equations.
I need to be sure that when I add a new line (when I click on my "Add Row" button) that the newly created "Total" field doesn't read from the previous row but recognizes the new data on the new row. I hope this makes sense.
Any help would be greatly appreciated. Many thanks
Michael
