[RESOLVED] Th information in a ComboBox and reference to a database???

[Hamsori]

I have a problem getting the right information to a ComboBox.


I have a table in SQL Server that contains a list of names.
I want to get those names to appear in my ComboBoxes shown in the picture. (DONE)
I also want the list of names to decrease by the names already used in other ComboBoxes in that Form...


EXAMPLE:

So, lets say I have a list:
Name_1
Name_2
Name_3
Name_4
Name_5
Name_6

In the Form, there are 10 ComboBoxes.
I choose the Name_1 for ComboBox1, Name_2 for ComboBox2 and Name_3 for ComboBox3.
The options available for all other ComboBoxes should be Name_4 ... Name_6.
If all of the 6 names are filled, the rest of the ComboBoxes should have no option to insert into them...