How to do a data lookup field in a DetailsView?
<p>I have a master-detail page for Customers. Select a customer from the list and a details view opens with Name, Address...etc.</p>

<p>I've been asked to add a field listing the Sales Rep servicing that customer.</p>

<p>I want the new field to hold the foreign key to the SalesRep table: the  SalesRepID. An integer.</p>

<p>I am not sure how to "wire up" the ItemTemplate field for displaying the Sales Rep name in a label. Also not sure about the EditItemTemplate dropdown list of possible Sales Reps.</p>

<p>I know I need to create a datasource to retreive the Sales Reps into a dataSet.</p>

<p>Let's call it "SQL_Reps_source".</p>

<p>A DropDownList seems to only like a list of values, and doesn't seem to handle Keys and Values like a HashTable or SortedList would.</p>

<p>Any advice on how to go about this?</p>

<p>Thanks</p>
