AnsweredAssumed Answered

Comparing old field value with new one

Question asked by brunomesquita on Jun 16, 2011
Latest reply on Jun 22, 2011 by aammondd


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.


Bruno Mesquita