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.

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

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!