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!