To Edit lock a record, you need only place the cursor into one of its fields. This "opens" the record for editing and locks out attempts to change the date when made by other users or even in other windows by the same user.
Okay, that makes sense.
It should only lock that record though, correct? If the other user is in a different proposal then I shouldn't get a locked message, should I?
Actually, I didn't mention it but it appears that I am not locked out. I can make changes without further messages.
Is there any way to tell which record/table is causing the message?
Not easily. Do you have any scripts excuting when you access this layout? Do they modify data in a field?
The lock could be a related record in a portal that is locked by user 1.
I have a script that runs when opening the layout. It was in fact setting the value of a field that is shared by ALL proposals. I was setting the user name when I wasn't sure how I was going to do security.
Since I don't need to do that and NEVER did, I disabled that one line and problem FIXED. Curious that I never saw this during testing with two people, only after setting up the security.
Thanks again, Lanny