hi,in each table of my system, i added two fields to record the last update timestamp and the last user_id who performed this update (using Row_Updating event to save that information)is there a way to “trigger” an event during the time the user is actually working in the “edit view” of a record.
i can imagine a popup to say "hi, there is your body who’s watching the same record as you, so be careful of what you’ll update…"my aim is to alter him that a another already update the same record he’s working (editing) now.
As i already have my 2 system fields in my tables, i just need a even to trigger and a way to display the message before he press the “save button” and erase the old record (updated by his partner).my dream feature would be a simple javascript message (or other kind of notification on screen) depending of the data in my 2 fields (by comparing the update user id with the actual user id and the update timestamp).do you have any clue to perform that kind of alert ?
The arbei’s answer in this topic should help you handle the case: http://hkvforums.com/viewtopic.php?f=4&t=46129#p146372