AnsweredAssumed Answered

How to automatically store updated record history?

Question asked by sundown on Dec 30, 2009
Latest reply on Dec 31, 2009 by sundown

Title

How to automatically store updated record history?

Post

Question: I have a database in a table that I update some client records several times with a performance review. I want to store (archive) the updated records (probably in a separate table) each time I update them so I can later retrieve the multiple performance records.
I don't want to add multiple records of the same client in the operational table, so I assume I need to make another table to store them.
How do I transfer (with a script) each set of updated records to the new (archive) table?

 

Outcomes