Hi all
I have seen some functionality in another database and would like to add it to mine but I have no idea where to start. I was hoping someone would be able to point me in the right direction to a tutorial or sample database that could help me.
What I would like to do is record when changes are made to specific tables. For example, in a vehicle table, if the vehicle is changed from active to inactive for example, the date, the value that was changed and who did the change would be recorded somewhere. I'm guessing another table.
Can anyone point me in the right direction.
Thanks
Craig
I have seen some functionality in another database and would like to add it to mine but I have no idea where to start. I was hoping someone would be able to point me in the right direction to a tutorial or sample database that could help me.
What I would like to do is record when changes are made to specific tables. For example, in a vehicle table, if the vehicle is changed from active to inactive for example, the date, the value that was changed and who did the change would be recorded somewhere. I'm guessing another table.
Can anyone point me in the right direction.
Thanks
Craig
