Keep price history

[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!

[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