I am working on creating 'changed' archive tables for several of my main tables for the purpose of creating an audit trail. The mirror tables have the same structure as their counterparts, but with two additional fields: Username and Modified (DateTime). When a user edits or deletes a record from the original table, a copy of the original record will be appended to the archive table. The edit/revert/save code is in a container class, and performs the tableupdate()s and tablerevert()s. The plan is to call a 'sendaudit' method in my form that will write the new record.
Has anyone implemented this before, or know where a good example is? I had planned on using SCATTER and GATHER, but am getting caught up in many of the details. Any helpful hints or pointers would be greatly appreciated.

TIA
Erik Moore