title: Putting relational query results into a combo box
body: <p>I have 3 tables with the following columns in my database:<br>
  tool: toolid, tool_name<br>
  facet: facetid, facet_name<br>
  tool_facet: tf_id, tf_toolid, tf_facetid</p>
  
  <p>The third table contains a list of tools and their facets:<br>
  e.g.<br>
  1  tid2 fid3<br>
  2  tid2 fid4<br>
  3  tid3 fid2   </p>
  
  <p>where tid2 and fid3 are ids for tools and facets respectively.</p>
  
  <p>In another combo box the user has chosen a specific tool. I want to now display the facets that apply to this tool in another combo box.</p>
  
  <p>Any suggestions?</p>
  
  <p>Thanks.</p>