How to build a form that searches your database
I have built one form that the site owner uses to enter information into the database. Next I need to build a form that the customer uses to enter information using the data that the site owner entered (this data should now show up in pull down fields). The customer then needs to enter his personal information (name, phone, email). Once the customer submits the form I need to use the information that the customer entered from the pull downs to search the site owner entered records and find which records match. Then I need to email the customer contact information to each party that matched the customer query, I also need to send an email to the customer. I know this can be done, I just don't know how to get there from here. I am using Drupal, MySql, Apache and have added the module "WebForm". I have the site owner form built. I think I need to use token values to make the pulldowns but haven't been able to figure it all out. I am in a time crunch and would really appreciate any help on available tutorials or how to do this.