I have a database of 15,000 funeral homes. I would like to create a field/combination of fields which allows a user to select the funeral home they are searching without having to hit a submit button, i.e. either the user selects a state, then city, then the list of funeral homes narrows to only those in that city. Another alternative is that a user would begin to type the name of the funeral home and a list of relevant funeral homes would appear. In either case, more than just the name would be necessary as many funeral homes have the same name; it would probably have to be a combination of the name and address in order to make the selection.
The website is built on Drupal 5 with a mySQL database. I've made several attempts using multireference fields and several Drupal modules. You can see these attempts at [url removed, login to view] You will need to create a login to view this page.
I am looking for someone who can write the code and/or provide specific instructions on how I might be able to do this. I don't believe that this project should cost more than $100
Please specify any experience with Drupal in your response.