Populating DropDown List in DetailsView Edit Mode.
Here is my dilema. I have a DetailsView on a form that displays an affiliate record on a webform. The information is updateable by the user, but one of the columns "affiliate_make" can be one of 35 options that are stored in a different table. To be specific, auto manufacturer.
So... When the affiliate goes to their account info page it shows their record, and in this example we'll say it shows they are a "Ford" dealer. However, when they edit the record to change address or any other information I want the dealer_make column to be a dropdown list of the auto manufacturers stored in another table. Preferrably with the one they already have selected having focus.
Can this be done?