how to create Changes Log.

[nyrob609]

Hi,

I have several tables and I created fields to capture when records is created and changed by date and username Before Insert and Before Update. What I would like to do now is keep track of old value on separate table. any assistance will be greatly appreciated.

Thank you

 

[boblarson]

Check out this free Audit Trail. It works great (I use it) and is easy to implement.

 

[nyrob609]

Thank you...this work great...

 

[boblarson]

Glad we could help.