re: _usermod & _timemod backups
Hi me again!
Just another one (I am sure there are going to be many more! <giggles>). I have been asked if it is possible to permanantly record who has modified a table.
What i thought was to create a new table - MODIFICATION RECORD - in this I want to sequentially store who and when someone has made a record within that table - this may be best done as a seperate database (advise me please!), what I thought was to have the following: _kp_Mod record (auto enter serial number), _kf_primary key table, user mod, mod timestamp as the fields. Then I thought about a script for the layout that copies the user mod and user timestamp from the main table on exit of that layout - is this the best way/ only way or is there an easier way to keep a long term track of who has modified a record?