A
Atlas
I have a form with a subform from two related tables:
Form (table): Payments
Subform(table): Details
As working with ADP and multiuser environment, When users are editing
subform details I want to lock the "parent" on the main form, disabling
other users to enter details on the same "parent".
Is there any (easy?) sample to do so?
It should work in this way:
User A enters subform data
- Lock parent
User B selects same parent
- Check if locked
- if so, alert user (message) and disable editing on subform
User A ends editing on subform
- Parent is unlocked
This brings quickly to two considerations:
1) Whenever a user is navigating records with focus on the subform (this is
possible by using navigation buttons), the related parent is locked - A
coffe break can lock the parent for quite long time!
2) If the application crashes, the parent lock will still be there?
Atlas - Rookie on the run
Form (table): Payments
Subform(table): Details
As working with ADP and multiuser environment, When users are editing
subform details I want to lock the "parent" on the main form, disabling
other users to enter details on the same "parent".
Is there any (easy?) sample to do so?
It should work in this way:
User A enters subform data
- Lock parent
User B selects same parent
- Check if locked
- if so, alert user (message) and disable editing on subform
User A ends editing on subform
- Parent is unlocked
This brings quickly to two considerations:
1) Whenever a user is navigating records with focus on the subform (this is
possible by using navigation buttons), the related parent is locked - A
coffe break can lock the parent for quite long time!
2) If the application crashes, the parent lock will still be there?
Atlas - Rookie on the run