I'm looking for a module that will turn a text field that is used to collect say a city name through a text field when a node is created into a drop down list when that field is exposed in views.
Also I need the module to only list each entry once. So say I have a field called (city name) and there are 20 nodes with the city name Vancouver I only need to show this once in the drop down.
I was going to use the Auto-complete Widget module but after testing seems it doesn't work with Contextual filters and I think a drop down would be better for people with JS turned off.
I've included a screenshot of what I'm looking for.