How to track row updates

Hello,
i have a table where i need to update certain columns, but i would like to keep track of any update.
example
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”.

thanks

0 1 243
1 REPLY 1
Top Labels in this Space