Multiuser record modification tracking ?

October 1, 200619 yr

Hi everyone,

(file attached with my first attempt at solving this problem)

I have built a job applicant management system and would like to add a way for users to determine whether a record has been updated by someone other than themselves. I want the modification functionality to be scripted because I only want certain important modifications (like a file upload) to trigger the record as "modified".

A few issues I have are... 1. I'd like the user to be able to indicate that they've seen a record on a record-by-record basis AND on an all-records-at-once basis. and 2. I'm not exactly sure how to approach the problem of what happens if a record gets modified while another user is logged in. The simplest way I've though of handling that has been to show records modified since the time of a user's last official review time.. and at user logout, ask the user if they want to set the new review time as the time of their current login. That way records modified during their current login will be picked up the next time they login. (in reality the important modifications that need to be tracked are being done at night, and though this approach is crude.. it might work for me)...

I'd be very interested in hearing how this problem has been tackled by others... and would love your help with picking holes in my first draft of this solution.. as well as ideas for how to do it differently, make it better.. etc.

thanks in advance

multiuser_modified.zip