> This preserves a logical separation between the original selection and the > filtering, but I think it risks de-optimization of the query (for instance, if > the original selection column and the filter column are part of a two column > index, I'll bet R:Base will not use the full index for the retrieval).
An example of my own use: I have a CheckRegister table that has multiple checking accounts in the same table.. The first temp view is a where clause displaying only the selected Company... The second is after form display, when I want to display Checks written to Only one vendor... A subset of the original..
