Hi Chris,

You don't want to open the table, you only want to open the view. And you only want to set the buffering on the view, NOT the table.

Think of views as updatable pictures of your tables. You use the view, make changes to the data in the view. Then you can save the changes in the view back to the table (tableupdate) or discard those changes (tablerevert).

If you open the view and the table and they are both buffered. You will have to tableupdate the view (which will apply those changes to the buffered table) and then tableupdate the table as well.

With views VFP will open the underlying tables by itself, there is no need for you to do it.

Look here in the KB for article#442 'Data Buffering in Visual FoxPro' by John Koziol. Click the KB link in the left frame, click articles, the VFP in general. It explains buffering and views and should help you out.

hth


>When using a local view, what is the best way to open the table and the view? Do I set buffering on my table and view, or just my table, or just my view? The view will be used to view and edit info. Also is best to insert new records into my view or table and requery my view?
>
>Thanks Chris