Hello, Here is my Problem:
I need to change the price of many parts, the problem is that if I change the value of Price, then all the records in the table orders which had the old price also make the change. Is there a way of only affecting the change to new records and not to the old ones? Should I make an Archive Table or it will be affected as well? Thank you for your help.