Hi Kevin,
Thanks for enlightening me. I have a few question though regarding the use of Update Triggers in Audit Trail.
1. If the system does not use Windows Authentication and maintains its own list of users, how can I record the user who edited the record?
2. A module like Purchase Order contains 2 or more related tables, how can I audit that the records in table1 and table2 were edited in Purchase Order Module and were audited by user1?
Thanks in advance...
Music Rocks
www.musicreserve.blogspot.comSuccess is 1% Inspiration & 99% Perspiration
God Sometimes Delays His Help to Test Our Faith and Energize Our Prayers
Our Boat May Be Tossed While He Sleeps, But He Wakes Up Before it Sinks.