I’m using C sharp as a front end to SQL server both are express.
I have 3 tables
tblCall, tblFSE and tblStatus
I drug from Data Sources to the form the controls from tblCall. And they setup nicely navigate just fine and edit appropriately enough. Problem is I would like the combobox controls for IDStatus and IDFSE to drop down and show the contents of their tables. I tried making them bound with “Use bound data items” from their smart task
I have the Data Source set to tblStatusBindingSource
Display Member set to Description
and Value Member set to Description also
With my current setup it will drop down and display values from the tblStatus.Description. But it doesn’t display them unless I drop down. Otherwise it shows the IDStatus.
The tables are…
IDCall - primary
IDFSE - primary
IDStatus - primary
Am I doing the binding wrong?
Thanks for any help