I've created a parameterized view with two tables but wasn't sure whether to buffer the view, the underlying tables or both (or neither). My goal is to use views to see the underlying data, but then if I make a change to the view (and therefore the underlying data), want to see the updated info, etc.

In testing, if I buffer (optimistic table in all cases) one of the original tables and not the other, change values from both tables in the view and do a requery(), only the unbuffered table's data is refreshed in the view (even though in lookiing at the underlying table in the view, it seems to have been updated.

If I buffered the view and one of the tables, again change values in the view in fields from each of the underlying tables, but only do a table update on the view and then requery(), neither underlying table is updated.

This is all very confusing. Forsooth, can someone pray tell me whether 'tis nobler in the mind to buffer or not buffer (or to suffer the slings and arrows or outrageous data?

With apologies to Will -

Sylvia