>Hi John, Nancy and Eward,
>
>Since I may have instigated this thread today let me elaborate on my situation a little. I have 5 tables related but each is on a different tab in a pageframe. I guess that's the same form? Since the user can't release one 'tab' without releasing the entire formset/pageframe. This is an app that I wrote years ago in WinFoxPro 2.6 and I'm converting\rewriting in VFP 6. It has 3 Formset/pageframes. The app schedules home health aids for shut-ins.
>
>One formset/pageframe contains a tab for Patient name, address etc., another tab for Patient health data, another one for Client data - who sponsers this patient, and one for schedule times and one for related task orders.
>
>The other formset/pageframe contains 5 more tables. A a table for data for the employees that would be available for task order assignments. Another tab for their Skills, Another tab for preferences(Smoking, Pets), etc.
>
>The last formset/pageframe contains just task order data from 1 table.
>
>Based upon what I learned from all the responses either optimistic or pessimistic row buffering on all 5 tables would sufficient.
>
>Thanks all.
>
>Regards,
>
>Paige

I would not subscribe here. Pessimistic buferring is tricky and is not used much because of this. If application design/flow really requires something 'pessimistic' then it's usually RLOCK(). Optimistic buffering is standard way to go, and usually it applies row buffering on tables and table buffering on small-set views (this is purely theoretical assumption from my side, because I don't go with buffering much).