>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
I guess, it would more applicable for your situation to utilize stored procedure on SQL-Server accepting parameters (search type and criteria values) from VFP front-end.
Edward Pikman
Independent Consultant