Update query then record changed fields in new table

[batwings]

Hi There

I have an 2 tables that I am comparing and an update query and it works well when I use it to update changes from my tblUpdate to tblMaster I've even manage to have the records that have been updated marked with "U" in a field called Flag.

But what I would really like to have is a 3rd table to log the history and by history all I want is the ID field for the record plus the field(s) that were changed and what they were changed from/to.. I do not need to know by who, what computer, time, date or any of that. (At the moment I know what record was changed but not what field(s)...)

I have seen this done using forms and subforms in an Employees/Salary scenario it looked great but I have no need for forms.

Just some way to record in a 3rd Table exactly what has changed...

Or if there was some way to highlight the changes in one of my tables emboldened/coloured or whatever showing just which field(s) had changed in each of the updated records that would suffice...


B

 

[neileg]

You can't do this at table level because Access tables don't support triggers. Do a search for audit trail in these forums.