locking sub-form only

Greetings.

I have a form with a subform. Main form is attached to table of
branches of our company, and sub form is attached to an orders table.
Two tables are linked through branch id.

When a user edits an order line the entire branch record is locked,
and no other user can edit orders. However I just want to lock that
specific order line, without blocking access to the entire branch.

For this to happen which lock setting must be applied to each form?
Currently I applied recordwise locking to subforms only but it doesn't
work.

Thanks

Re: locking sub-form only

On Mon, 3 Dec 2007 06:47:57 -0800 (PST), Cagdas Ozgenc
wrote:

If properly implemented this problem would not occur. Just for kicks,
run the Northwind sample application and observe several users can
edit OrderDetail rows, while others edit Orders.

If I had to speculate, I would think your subform query erroneously
includes a join to the Braches table.

-Tom.


>Greetings.
>
>I have a form with a subform. Main form is attached to table of
>branches of our company, and sub form is attached to an orders table.
>Two tables are linked through branch id.
>
>When a user edits an order line the entire branch record is locked,
>and no other user can edit orders. However I just want to lock that
>specific order line, without blocking access to the entire branch.
>
>For this to happen which lock setting must be applied to each form?
>Currently I applied recordwise locking to subforms only but it doesn't
>work.
>
>Thanks