Is there a way to automatically modify values in a database.
For example, lets say my form stores 3 values, Value1 = 4000 Value2 = 5000 Value3 = 6000
Now, what i need is for the number 4000 to become "Cost", value2 to be "Expenses" etc. Ideally, if there is a way to modify those values as soon as they are entered, that way i can retrieve them right away.
Not quite sure I understand what you are asking...
Am I right in assuming the following? 1) You have a form with 3 text boxes where the user enters data called Value1, Value2, and Value3. 2) You have a database table with fields named "Cost" and "Expenses." 3) You are asking how to take the data entered in the form and modify the existing values in your table.