Search Page with Multiple Dropdowns
Using DataAssist, I have created Search pages with multiple selectable field option dynamic drop downs from data base table (example: state, countries). Sometimes, I only want to search by one criterion. Currently, the values from the table display in each of the dropdowns.
The field could be just a “text field” but I was hoping to be able to provide a dropdown to allow for a search based on “known/used” values. I have tried with a blank “Select value equal to” in the Dynamic List/Menu. But that did not work.
Without having a “blank” value in the db table, how can I have it display without a value? Then allow using the dropdown to select?