>Ed,
>I went to my view designer and filter tab set like this.
>customer.account = ?lcAccount
>customer.saddress = ?lcSaddress
>total of 8 filters
>
>
>when I run my customer form which is a view and from a command button bring in a form that I can use to search I have textbox(s) for account,address, etc If I key in information in the address field and keep the account field blank out of the valid of the address textbox I select my view and requery the view and it will ask me for a account value. Before I select the view I can say lcaccount = '' and I will not get that nasty window ask me for the account value.
>
>My order tab is:
>account
>sname
>last, etc
>
>Is this procedure OK or am I going to run into a performance issue when I have a large amount of data

So it's search form and you want to search by phone number? I think you may better use cursor with flexibly built Where clause of Select-SQL command. Realistically speaking users will not enter all 8 criteria and Where clause will pick up only entered ones.