Tom: We did the exact same thing! Added an integer column to a very important data table. Immediately updated it with a "1" if you went to edit the record, back to "0" when they exit. A notice to another user saying that the record is being edited and to try again in a few minutes.
We later upgraded it to also store the User Name of the person editing. So the message to the second user now says "Tom is editing this record", in case Tom is having coffee and left his screen up. Karen > Marc, > > After screwing around, we developed a simple solution. I am sure there is a > much more elegant solution, but this worked great. Add an integer column > (ID_Open) to a table (Info) that will track when someone is editing a > particular > row. Field default is 0 which means no one is there. 1 means someone is > editing that row. Use UPDATE to change ID_Open for that row. Something like > this > in a menu Bit Button EEP does the trick and is easy to move to other buttons. > : > > >
