IMO, the best thing is to let the user fill in the view parameter and click a search button.

>Thank for the answer. But I have to rephase my question. I opened all the files including the big one in Data Env. or in the Load (of the form) . The form is opened with a grid filled with another table in relation with the big view (SET REALTION ....INTO the big view). It is very fast because I loaded the big view with NODATA, butI have no info from the big view yet. Now before I do anything, I need my big view to be fill up. So the question is: Where do I have to fire the Requery() (Activate, Refresh, etc... ? ) in order to obtain the max performance (i.e. user don't have to wait too long... :-))
>Thank again,
>
>VSN