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.
is there such a thing? Thanks