Database record changes - How to audit?
Posted on 2015-01-28
I have a table named tblAudit. In this table in addition to an auto-number ID field are 7 fields. They are:
EditDate, User, RecordID, SourceTable, SourceField, BeforeValue, and AfterValue.
Any time a change is made be it edit, addition, or deletion is made I need the audit table to have a record made to it capturing the values. How can I do this? Do I need some code for every form? Or a module that works for every change?
What would to code look like? I've never done this before.