Start New Discussion within our Databases Community

Hey guys

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 ??


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.

This article has been dead for over six months. Start a new discussion instead.