I set the DataSource to the table. I set the DisplayMember to Area_Name and the ValueMember to Area_ID. The ComboBox shows all the values for Area_Name including duplicates. I want the ComboBox to just show a list containing 4 values: N/A, Unknown, Test, 4CL. The ComboBox has to account for different Areas being added and deleted from SQL. I thought binding the Area_ID to ValueMember would solve this. Any help is appreciated.
An example dataset in SQL Server Management Studio:
Area_ID | Area_Name --------------------- -2 | N/A -1 | Unknown 2069 | Test 2069 | Test 2066 | 4CL 2066 | 4CL 2066 | 4CL