Page 1 of 1

Keep price history

Posted: 2020-09-24 16:22
by tvloeimans
I'm making an app for product info and want to keep track of any price changes (buy and sell).

I add 12 fields to the itemtable with date+prices, don't think that's the best solution.

What would be the best way to do this?

Thanks!

Re: Keep price history

Posted: 2020-09-24 20:30
by angus
Hi tvloeimans, you could add an audit function on the table. This will track all changes to the table

viewtopic.php?f=4&t=1369&p=6121&hilit=log+in#p6121