The precedence order is (the top one has precendence over the next):
- BufferModeOverride of each table/view in the DataEnvironment
- BufferMode of the form
- Tools|Options|Data

I just tested it with pessimistic table buffering and it gave me an error when I tried to update the second instance. Are you using a view?

---

>Yes all of the controls are linked. I discovered that with pessimistic table buffering, the change to the second session isn't being accepted. It just fills in the new values from the first session. I expected a generated error. Looks like I have to check the return of TableUpdate() using this method as well.
>
>One thing still confusion me is the multiple places the buffering mode can be set. It can be set in Tools->Options->Data. It can be set in the cursor properties and by using code. What is the precedence order?