I have a form with 4 tables displayed in different tabs, all coming from the same dataset. Here's part of the Form.Load event so you know what I mean:
What I need to do is lock all the records that are opened in the latter 3 lines and begin a transaction. Then allow the user with the lock to add records to the first table and modify contents of the next 3. I'd prefer that other users simply not be allowed to even view these locked records.
Saving needs to be in a transaction, meaning either save ALL 4 tables or fail on all.
I can do this when I do everything programmatically, but I'm a bit lost when it comes to using objects from my Datasource window.
I'd appreciate any help.