Hi,

I'm trying to make a Search Form for different games.
I have 2 comboboxes, combo1 filled with the Field Names to select a field to search in. This works!

Now i wan't the second combobox to fill with all the items in that field, BUT:
If there are more then 1 equal items in the field, it should only enter it once.

example:
ID_____Type_____Group_____Name__________Extra
1______Computer_Racing____Need For Speed__Most Wanted
2______Computer_Sports____Fifa10__________Football
3______Board____Cards_____Patience________Cardgame
4______Computer_Racing____Need For Speed__Undercover
etc.

I allready have the fieldnames in combo1, but i want combo2 to be: (If combo1 = 'Type')
Computer (1x)
Board (1x)
etc.

Thanks in advance!