How to create archive record when editing a row

monkeyboy

Hello Allan,

When my users edit a table row, I need to copy the old record, and flag it as an archive. The edited record needs to actually create a new record in the db and log the user ID of the person responsible for creating the edit.

How can I add that functionality, or intercept the editor update to have it use my code?

This history is critical to my application.

Thanks

monkeyboy

For clarity's sake: The log of responsible user is entered into the NEW record which includes the updated fields

allan

Sounds like a perfect use case for the server-side events that the Editor PHP and .NET libraries trigger (not sure which you are using, if either).

This blog post on the topic might also be of some interest.

Allan

monkeyboy

Allan! You Rock! You surely have thought of every possible requirement!