To "Cascade Update" or Not

[Jester0001]

In designing my database, I will have a table with the name and price of products, which will be linked to an orders table. However, if the price of the products needs to change in the future, how can I keep the data to update the new price to only new orders, and keep the original price the same for all previous orders?



DoI want to uncheck "Cascade Update" on my relationship? What about "Cascade Delete"? I hope I am understanding this correctly.

[pbaldy]

Typically you would save the price of the product with the order. That field would not be related to the products table in relationships, and would not change when the products table price was changed.