Text box display based on drop down list
<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>
