CREATING AN AUDIT/MODIFICATION LOG
I've been trawling through forums trying to find a way to write a script that captures changes to fields as they are committed, capturing the following components:
- account name of the active user
- the field name of the modified field
- its original value before the modification and
- the new value
Currently i can only get the first two auto-enter values to log in the database. Really need to capture "last visited record" and it's contents.
I've also tried to run the script with a related table in the same file AND related table in a separate database (thinking the latter may be less messy) but i've had limited success.
Any help would be SO appreciated.
Thank you so much for your time.