I have an aspx page with some form controls in it. They all work fine except for one thing, the control (list) that is populated based on the selected item in the first control (dropdownlist1) is only showing the element ID, not the "name" which I want.

So, I think I just need a pretty simple join query to get the name property.

I need to get the Capability name (capability_nam e) from the Capability Table...