By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,561 Members | 3,221 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,561 IT Pros & Developers. It's quick & easy.

Event Log Table

P: 47
I have a DB where I'm tracking mainteniance work orders, It works fine so far, now I want to add a table to store data about who and when is modifying a work order, the idea is once user clicks on a form save button a new row is added to the event log table with the WorkOrderId; userId( coming for a hidden form) and date/time so I can later track who did what,

any help will be much appreciated

Raymundo Walle
Oct 12 '12 #1

✓ answered by Rabbit

When they click the save button, add an extra line of code to run an insert query into the log table.

Share this Question
Share on Google+
1 Reply


Rabbit
Expert Mod 10K+
P: 12,366
When they click the save button, add an extra line of code to run an insert query into the log table.
Oct 12 '12 #2

Post your reply

Sign in to post your reply or Sign up for a free account.