Hi Aaron ---

How about create local temporary indexes on the desired fields in the Init method of the form....change via SET ORDER to the applicable index to search....the downside to this is that if it's a large table; you have to REINDEX each time you REQUERY.


>I have a form based on a remote view (from SQL Server). The view is setup to search on an order number input by the user. I would like to make an option for the user to be able to search by order number, customer number, other and still use the same form.
>
>What is the proper way to achieve this? I figured that I could code to create a new view with the same name based on the field the user is searching by - but requery() does not seem work when I do this - I must close the view and re-open in order to get the new results. is this the correct way to do this?
>
>I am in a multi-user enviroment and I am concerned that if I create a new view with the same name for the new search criteria that this could interfear with another user who is using the view with the initial criteria. (I have not tested this theory yet).
>
>Thanks to all for your help!!
>
>Aaron