One other thought about views, though..... If you need an index on a view, index it while it's still empty (with the no data on load). Then when you requery the indexes are automatically updated.
Barbara
>I understand, from a previous thread, that, in order to help a form load quickly, the tables accessed by the form should be opened at system start up. Does this apply to views also (I'd, oc, open them w/no data)?
>
>TIA, J