SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm using the DVWP to view and edit a few SQL Server database tables.

Is it possible to use a dropdown control to display values in an edit form? Let's say I'm editing a row in a table called Fruits, and there is a field called "Type" which is a foreign key reference to a table called FruitTypes. I would like to select the fruit "type" from a dropdown list bound to the FruitTypes table.

It's a pretty straightforward question, though I seem to be having a difficult time asking it. Thanks!

share|improve this question

The answer is "yes", at least fro a DVWP perspective. Check out my blog post on this:

share|improve this answer
I'm not sure that's what I'm after. I want only one of my columns to be a dropdown with values from a reference table. So instead of FruitType being "0" or "1" or "2" (the key), I want it to be "Apple" or "Orange", etc. (the value corresponding to the key in the referenced table). – Boden Feb 1 '11 at 22:04

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.