>We are trying to find a way to speed up our APP at a clients site.
>
>Client:
>[snip]

Shawn -
here's a good concept that works:

1. Make the views you need REMOTE views with parameters. In the filter condition tab of the view designer - change the field name to something meaningful for that table, condition equals [=] and then in the Example place '?vp_cqueryval'.

2. In the data environment for the form, add that parameterized remote view.
In the data section of the PEM box set the 'NoDataOnLoad' to TRUE [.T.]

Then, after your form instantiates - your user would enter a client number
in the textbox, and in the click method of the button you assign the vp_cqueryval variable to the number that they typed in, and then issue a requery.

If it takes a long time for this, then your table isn't indexed properly.

hth [Bill]