>Why cant I RLOCK the parent record?
>By the way, I DO use tableupdate() (inside a transaction) when the user clicks SAVE.. the problem is that it it doesn't run through my save method because only the sibling (not the InitialSelectedAlias) is getting committed.

I had a similar problem with optimistic row buffering and accessing the menu while adding/editing. This caused a TABLEUPDATE to occur automatically. I changed it to optimistic table and now all is fine. Maybe something similar is happening when you change work areas or run the SQL.

Also, there is nothing wrong with using RLOCK(). I use it all the time. When a user chooses to modify a record in my apps I have method code like:

IF RLOCK()
     Enable fields to allow editing
ELSE
     Show message "Record is being modified by another user"
ENDIF

Buffering alone does not handle this.   HTH

Colin Magee
Team Leader, Systems Development
Metroland Media Group Ltd.
Mississauga, Ontario, Canada

cmagee@metroland.com

Never mistake having a career with having a life.