Hello,
I have a form that I use for searching. It takes all the records in the database and then people can type things they are searching for - numbers, dates, names, descriptions etc. - into a text box, and as they type, the selection window shows fewer and fewer matches.
What I would like to do now is give the user the option to limit where the underlying query searches, but only if he wants to do this.
In other words, I want to be able to search the entire database [default], or only within a certain year, or amongst the products of one manufacturer, or a certain model etc. and I want to be able to combine parameters so that more than one can be applied at the same time.
I have 5 or 6 parameters and I was thinking of using drop-down boxes for the user to select a value for these parameters.
My problem is that when I specify parameters to limit the search, I have to have a value in all of them. What do I need to do to make those optional?
Thank you.
I have a form that I use for searching. It takes all the records in the database and then people can type things they are searching for - numbers, dates, names, descriptions etc. - into a text box, and as they type, the selection window shows fewer and fewer matches.
What I would like to do now is give the user the option to limit where the underlying query searches, but only if he wants to do this.
In other words, I want to be able to search the entire database [default], or only within a certain year, or amongst the products of one manufacturer, or a certain model etc. and I want to be able to combine parameters so that more than one can be applied at the same time.
I have 5 or 6 parameters and I was thinking of using drop-down boxes for the user to select a value for these parameters.
My problem is that when I specify parameters to limit the search, I have to have a value in all of them. What do I need to do to make those optional?
Thank you.
