title: Populate fields in webpage based on option selected from a drop down list using Classic ASP
body: <p>I have a page that has a drop down combo box, the values for which are coming from a database. next to the combo box are two text boxes.  </p>
  
  <p>now based on the option selected from the drop down list, I need to go to the DB and get relevant data from the db and populate the two text boxes.</p>
  
  <p>There are other fields in the page that are straight forward, but i don't know how to go about with this situation.</p>
  
  <p>any link/sample code/reading material / or any other form of help will be greatly appreciated.</p>
  
  <p>Thanks,</p>
  
  <p>Ok am thinking loud here, here's the sample code
      </p>
  
  <pre><code>   &lt;%
      While not rsRecordSet.EOF
      %&gt;
      &lt;OPTION VALUE="&lt;%=rsRecordSet("FldID")%&gt;"&gt;&lt;%=rsRecordSet("FldName")%&gt;&lt;/OPTION&gt;
      &lt;%
      rsRecordSet.MoveNext
      Wend
      Set rsRecordSet= nothing
      %&gt;
  </code></pre>
  
  <p></p>
  
  <p>I need the Value i.e. FldID as the reference to the data selected, but if i can tag the rest of the data somewhere. e.g. the other two fields need to show FldAge and FldGender.  I can get those in the rsRecordSet, and as i am populating the Option i can populate some tag and some how call it later depending on the option selected from the combo.  Just thinking loud here.  Thank,s</p>