Is it possible to change the value of a field and have that effect only records created after the change?
More specifically: I have a tax field which is a calculation. Tax % has changed and I need that reflected in future records, not past records.
I may have originally gone about this in a wonky way, but am embellishing a live database in a busy business.
Any ideas would be appreciated.