Hi all,

We are making a database, were we want to search in. So we made a combobox in wich you can choose a keyword where the database searches on. The combobox is based on a query which is indirectly linked to other data as for example names of people.

Now the problem is that the combobox shows the same keyword a couple of times. This because the keyword is linked to more than one person. For example if the keyword is linked to three people, it will appear in the combobox three times.
How can we make the combobox so that is shows every keyword just once? With a filter? Suggestions?

Tnx!

AB

hi there... this should be solved in the query, in your SQL just add a distinct after the SELECT statement...

(Something like "SELECT DISTINCT fields FROM etc...)

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========

Simple, if you know it.

Thanks a lot!

AB