I want to track latest Price change for an item.
The table name is res, field names are price, prevprice, priceupdatedate
I need help with writing a trigger that updates the field "prevprice" with the old price when the "price" field is updated and then writes the current time stamp to the priceupdatedate field.
code example appreciated! Thanks!