Avatar

Level 2

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