Extract changes in individual records in Back-end table (1 Viewer)

[123dstreet]

Hi all!

I have a table with multiple records (Complete Parts List Table). Whenever a user purchases, sells, or manually removes inventory, these records are updated in this table. Problem: There is no paper trail for the changes to these records. Is there any way to run a command so whenever one of these records is changed in the back-end, a report can be created to document the change in the data? It sounds easy in theory, but I cannot figure out how to get this to happen!

Any help is appreciated!

Thank you!

 

[pbaldy]

This is one of the reasons it's generally frowned upon to try and save a quantity on hand value. I just calculate it from transactions. If you want to stay with what you're doing, you might search on "audit trail", which would let you store a history.