I have linked a database to a windows form. I have dragged the field objects onto the windows form.
Prior to doing this I changed the first field object to a combo box and the last field object to a list item.
I have proceeded with the following settings for the binding by clicking the arrows on the relevant objects:
Combo Box:
Data Source = databaseBindingSource
Display Member = column1
Value Member = column1
Selected Value = none
List Box:
Data Source = databaseBindingSource
Display Member = column5
Value Member = column1
Selected Value = none
The Combo Box is working ok but the List Box is showing all the values in Column 5 I just want it to show the unique ones. I then need to be able to select a unique value from the List Box and it show all entries from column 1 that have the specified column 5 value against them.
I realise as I waffle this is not making much sense but any Ideas greatly received?