title: Text box display based on drop down list
body: <p>I have a drop down list that shows all of the job numbers that are current.  I need a text box to display the "name" equivalent of this number.  The drop down list is based on a query to a separate table within the same database.  The drop down list is:</p>
  
  <pre><code>&lt;asp:DropDownList ID="dlRef" runat="server" DataSourceID="DataRef" DataTextField="Ref" 
       DataValueField="Ref" style="z-index: 1; left: 155px; top: 68px; position: absolute; 
       width: 115px; height: 29px; bottom: 254px;" AutoPostBack="True"&gt;
  &lt;/asp:DropDownList&gt;
  </code></pre>
  
  <p>What I need to do is have the text box tbADName to be associated with a datasource that uses a query such as this select Name from ActiveJobs where Ref = dlRef.DataValueField.</p>
  
  <p>Is this possible or do I need to use another construct to display this information?</p>