Comparing old field value with new one
Hope I'm not posting an old questions, but I couldn't find any answers.
Here is my problem. I built a database to keep track of my product prices - it actually calculates the price based on some criterias. Right now I need to store the value of the field PRICE for later comparison, when the price is changed.
My idea is to store that field value as OLDPRICE and keep the new calculated price on the field PRICE.
Is there a way to do that? Hope someone can help.