var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Does anyone track changes made?
Does anyone track who changed the data and when? If so do you have a recomendation to me on how is the best way to track changes?
Create a table for the changes with a date, username, and previous value for whatever table you need to track.
I'm hoping you don't have to track much. If you only need to track information in one table, the above suggestion will do the trick. Multiple tables gets quite a bit more irritating.
Tracking multiple tables :-/
I was trying to track the:
User (when first put into database)
Date Entered (when first put into database)
WhoChange (u/n that changed something in the record)
ChangeDate (date that person changed that record)
Currently I have code in all of my forms that as soon as one thing is changed it sets the ChangeDate and WhoChange to DateTime.Date and CurrentUser respectively.
I was trying to simplify my code by creating a module so all I have to do is call a function that way it would save me alot of copy and paste for all of the like 20 forms I have.
Anything to help would be much appreciated. I dont really need to track the old value... just what the new one is. I need it in a module public function so I can call on it from any form.
Thanks so much,