AnsweredAssumed Answered

Creating "Advanced Search" Layout

Question asked by user16037 on Sep 23, 2011
Latest reply on Oct 21, 2011 by user16037


Creating "Advanced Search" Layout


 Level: Newbie

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.