How to Update product price for next order that don't to be change previous product price?

Write the price to a basic column in the sale table when a row is added instead of using a lookup to get the price.

Also for the future, a Rollup column is not necessary the way you are using it. The Lookup column should be enough as long as your relation is a single relation instead of a multiple relation. But for this case, you shouldn’t need a relation, lookup, or rollup if you write the price when the row is added.

1 Like