title: Processing dropdown selectbox options with ajax autocomplete
body: <p>I'm  not sure on how to do all of this, i've seen ajax / jquery autocomplete scripts but I want to query two different tables depending upon what is selected from a dropdown box. Is something like this even possible or would have have to combine the two databases into one</p>
  
  <p>This is what I want to do.</p>
  
  <p>Country: US , Canada (dropdown selectbox)</p>
  
  <p>If user select US Then query search_us table for the autocomplete on ...</p>
  
  <p>City or Zip/Postal: [      ] (textbox)</p>
  
  <p>Else If Canada is selected Then query search_ca table for autocomplete on ...</p>
  
  <p>City or Zip/Postal: [      ] (textbox)</p>