I am currently working on a product for searching a specific type of
database that has a nice small set of commonly used search fields that lend
themselves well to a neat basic search and a very long set of infrequently
used (but necessary) search fields that I am relegating to the "advanced
search" page. Now, the question is how to design advanced search. This
database can have up 150 search fields and it's obviously a mess to have one
giant (even well organized) form.
Have others faced this problem? I have brainstormed a few ideas but wanted
to open it up to commentary.