Modification Tracking

[dspires]

Has anyone approached the scenerio of having a field that tracks record modification history? I'm looking to track the "who" and "when" for the last 5 or so changes on individual records.

[rjoseph]

See http://www.swconsulting.com. There is an example of just what you want to do called Modification Tracker.

[fishma]

You can do this if your DB solution is set up correctly. If you have an edit screen, where the user must press a submit button to complete the edit, you can do this. All you have to do compare the old vale with the new value, if they are different, create a record in a history table. Set the user id, the foreign key, the modification time, the mod date, the old value, and the new value. That should about do it.

A complete history (Versioning) system, (including field level granularity, with roll back), is complex and far more in depth than I would care to get into. It depends on how agressive you want to be on this solution.

Fishma!