Is there a way to have a search form with multiple fields to have one or more required fields? For example, I have a form with three search fields: Name, City, and State (which is a dropdown list). I want to require the user to input a City and select a State. In other words, I don't want the user to be able to just search for any Name in a particular State, I want the user to only search for Names within a particular City in the State - primarily to limit the number of results.
I tried using a dropdown list for City (as well as for State), but the dropdown list is not limited to the cities for the particular State selected; instead it shows all of the distinct cities for every State.
I would also like to be able to make the City and State optional if the user inputs a Name for the Search - would this have to be done as a separate DataPage, or could the DataPage have two optional forms of search - search by Name or Search by City and State?