duplicate records in search drop down
I have a dropdown menu lists that are dynamically getting data from a datbase table, the dropdowns show duplicate record names, e.g if there are 10 cars all called Astra, then i get a list of 10 "Astra" what i want is 1 Astra and when you select it it shows all 10 in the results page. How do i get around this!
Mike