im populating a combo box from my database i was just wondering how do i prevent the combo box from displaying different instances of the same value. e.g three B&Bs all from ennis. ennis is in the combobox but its displayed three times.
how do i stop this ??
Show the query you use to retrieve the values (and some sample data would be helpful too).
I agree with @pritaeas but off the top of my head, use DISTINCT in your query to only retrieve one instance of the same value.
Thanks Guys Distinct srted it
You can use distinct or Group BY, either of that works.