i have a table where i need to update certain columns, but i would like to keep track of any update.
item ----- price
apple ---- 1$
pear ---- 2$
i can create an order
order n. — item — Q.TY— price — total
uniqueID — apple — 20 — 1 — 20
so when i go into my table i have a ref action to see the history of any “apple” order.
Now i want change the price; 1.20$ for example.
The next order will be recorded with the new price and everything works, but i would like to track also the price change when i press the view ref action because is part of the history of “apple”.