Creating "Advanced Search" Layout
I am re-creating an "advanced Search" page for a library catelogue. for example:
I am having trouble with the requirement to make a single text entry field that would search nominated fields depending on the drop down field on the left.
So, there are a couple of things here: can a field be made to search different field depending on the input of another field?
Secondly, and this is a concept question, these fields do not need to hold information in a record form there are there just for purposes of enquiry. I have created them but each one is adding another field on every record and this is a database of 53k records so has create a whole lot of nothing which, I assume, reduces the efficiency of the db. Are there temporary fields that can be created for this purpose?
Thanks for the help. Having read a lot about the system off and online my head is starting to hurt! Touble is I am not too sure how to define the problem to search the forum.