I have the standard scenario:

1. A lookup table, call it "Values". This table has 2 columns: Value_PKey and Value_Desc.

2. A data table, with 3 columns storing foreign Value_PKey values (they will be different).

I'd like to configure dropdown lists to show the current values of the 3 data columns, plus all the other available choices so each may be changed to a different value.

I've gotten to the point where I can either DataBind() to a DataTable to populate the dropdown items, or spin through the DataTable and populate manually with Items.Add(). However, I don't see how to attach a separate DataSet table (or whatever) to this dropdown list.

I'm probably missing something fairly fundamental. Can anyone point me to an online tutorial or code sample(s) that shows how to do this?