[RESOLVED] A dropdown list question
Hi,
I have this drop down list which is populated with the proc below. Can anyone tell me how to keep the fields shown as the key fields but for added detail in the drop down I want it to show two more fields from the data source?
VB Code:
Private Sub bindDropCarriages()
Me.DropCarriageNo.Items.Clear()
'Get Available Carriages
Me.DropCarriageNo.DataSource = Main.objCarriageBuildSheet.vwCarriages
Main.objCarriageBuildSheet.vwCarriages.RowFilter = "Despatched = False"
Me.DropCarriageNo.DataTextField = "Lift Serial Number"
Me.DropCarriageNo.DataValueField = "Lift Serial Number"
Me.DropCarriageNo.DataBind()
End Sub
Or to simplify the question can I have more than one column in the dropdown?
Re: A dropdown list question
After some research it can be done but doesnt look like it can be done and be databound.