We use a button based menu system to access all the forms which use a row. We currently use a simple row update that sets RowOpen =0 as open or RowOpen=1 as locked. If another user tries to use the same row while RowOpen = 1, they get a message basically saying 'Come back later' and gives the current users name. It works but the value of RowOpen does not get reset to 0 if a user drops out of the database in some odd way.
ROWLOCKS works, but if I am editing MEDICAL info for Mary and another user tries to enter the same row on their computer what they see is a Menu button that does not respond until I leave that row. Is there a system variable that shows the current status of ROWLOCKS for a specific row that I can use to send the 'Come back later' message? Tom Frederick President/CEO Elm City Center 1314 W Walnut Jacksonville, IL 62650 W- 217-245-9504 F - 217-245-2350 E - [email protected]
