Multiple Search Fields in a DA search.

Hi guys,

Heres the deal; I have a data Assist setup for a listing of employers. What I need to do is to be able to search that data by Company Name, City or Province or any combination of these.

Ideally, what I would like is a drop menu for Province, which then would populate a second drop down with cities that are in that province. Then have a text box that could optionally be filled in with a company name (Even better if it could populate another dropdown based on the employers in the city selected in the second drop down.

Can this be done?

Thanks,
Brad

This definitely sounds like something that you could do with DataAssist, but the dynamic dropdowns part would need to handled with our Dynamic Dropdowns tool. Essentially this is the same as a search like this that would have text fields. The only difference is that after you have configured the search and results page you would replace your text fields with these dynamic dropdowns that have the same name. This would give you the same result as if you had entered the exact same values into your text fields.

So the first step in this is getting the search and results set up and working. Once you do that you can add in a couple of recordsets then the select lists and start applying Dynamic Dropdowns to them.

Thanks Eric,

I will give it a try. Crossing fingers .... this looks like it will be complicated to do. ;-)

Brad

Thanks Eric,

I was able to get it to work with one exception. You cannot multi-select from the list. It will only return results for the first item selected in the list.

Is there a way to still allow multi-select?

Thanks,
Brad

PS: This worked even better than I expected and was fairly easy to do.

Yes, you can make use of multi select lists for the searching. When you are working with a multi select list you should choose the edit type of 'list' in the DataAssist Search server behavior. This type of search can take an array of values instead of a single value.