Hello,
I have created a form that contains a table that currently has one row and several columns. To add additional rows/columns the user would click an "Add Additional Rows" button. . One column of the table name "FeeDue" would be used for numeric values. Those numbers would be added together in the "Total" column. When numbers are enetered in a column named "Ramount" those numbesr would be subtracted from the "Total".
Everything works with one exception -- The number add correctly, the first subtraction works correctly, but when I add a new row the subtraction in that and any following rows do not..
Also, is there anyway to get the numeric values from a drop down list to add? When I try to do so, I get a number 1 or 2, and not the actual number.
This is the script.
---------------------------form1.DV.Subform2.Total::calculate: - (FormCalc, client)-------------------------------------
sum(Table1.Row2[*].FeeDue[*]) - (Table1.Row2[*].Ramount[*])
-------------------------------------
Also, is there anyway to get the numeric values from a drop down list to add? When I try to do so, I get a number 1 or 2, and not the actual number.
Thank you
