Hi All
I am creating an issue tracker and I would like to create an audit trail of sorts.
All I need to capture is when the value of 3 fields are changed (What it was changed to, who changed it and when it was changed)
For example
The field is Status. It has a value of "OPEN", a user who is recognised within the database (the username will be passed through after they log on) changes the status to "RESOLVED". I would like a record of that change appended to an Table (tblAudit). It would need to record the old status, the new status, the user, the time, the ID of the record that was changed.