Here is my search page
How can I limit the search with multiple criteria?
Another words if I enter a city it will give all records with that city
If I enter a city and a state it not only gives all the records with that city but it gives me all the records with that state.
I want to limit the records to that city within that state.
I tried the "and" criteria but it does not return any records unless all the fields are filled out
Also how can I use wildcards ( " * " ) in the search?
P.S. I want to do this within Frontpage and not have to use "html" or "asp" code.