If your field people know what records they'll be working on, one
approach is to have them 'sign out' the records from the database that
they'll be working on remotely. The signing out would include the
date/time and userid, and the rest of the application would have to
"honor" the signed out status, showing people that the records are
"signed out", and letting people read the records, but not update them.
If you take this approach, you need to "sweep" the database regularly
looking for records that were "signed out", but not "returned".
Allen Egerton aegerton at pobox dot com