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
User | Count |
---|---|
44 | |
35 | |
25 | |
24 | |
15 |