Hello..
I have a table with a field name called 'Professions'. There are many same multiple values for this field, for example, there are many records with the value 'Doctor' under this field.

Here are the values under this field in the table:


Lawyer
Lawyer
Teacher Scientist
Doctor
Engineer
Doctor
Doctor
Mechanic

I want to make a form with a combo box where the combo box shows values under 'Professions', but I do not want the value 'Doctor' to be repeated more than once in the combo box... How can I do this??

I have already tried creating a combo box query, but then the value 'Doctor' gets repeated more than once in the combo box because of the many records...

When I open the combo box, I get these values:


Lawyer
Lawyer
Teacher Scientist
Doctor
Engineer
Doctor
Doctor
Mechanic

but what i want to get after opening the combo box is:


Lawyer
Teacher Scientist
Doctor
Engineer
Mechanic


How do I do this? I hope I've made myself clear...