form calculations

[Techknownothing]

I have a FORM that performs some simple calculations.
It uses field3 to calculate the price per square foot of a building
when I enter data into 2 other fields, field1, AREA and field2 PRICE.
It works fine but it does not write the data into the table the form is
bound to. How can I make it enter the data into the table?

Jeff

 

[Guest]

First, you should not be doing this. Calculated values should not be stored
in tables. It wastes space, time, and is prone to errors because things very
often happen that causes something used in the calculation to be changed.
Only store static values. Do the calculations where you need to display it
for users or use the calculated value in another calculation.