I would like to clarify the concept of record-level locking
Say I have a TBLA which consists of two fields TBLA_FLD1 & TBLA_FLD2
&
TBLB which consists of three fields TBLB_FLD1 & TBLB_FLD2 & TBLB_FLD3
Now two users have declared the usage of the database as shared and pessimistic
I have generated a query in addition to TBLA & TBLB which is QryCombined which basically just a join of the two and consists of all five fields
If user1 has brought in a record query from QryCombined and edits on TBLA_FLD1 & TBLB_FLD3
At the same time user2 is trying to bring in as well QryCombined but with TBLA_FLD2 & TBLB_FLD1 and trying to edit both, will user2 be blocked by user1 who's editing the other fields
For all I know, the locking is based on record-level locking so I would suppose one record of QryCombined will comprise of all five fields so editing in any of them should actually block another user from editing. However I am not sure whether it is just a subset of the record that is the contesting area because user1 recordset has only two fields out of five, which do not happen to intercept the other fields that user2 is working on.