HELP - Custom DRW Drop list using DISTINCT

[Mettá]

I am having real problems with something that DID WORK and is now refusing
to work. It might be me forgetting something but I have a nasty feeling it
an update or but thats causing this one?

I have three fields, two of which are drawn from a db based on the 1st and
then a result based on all three...

1 is a text box - the user enters a word or string, say "yoga" and presses
search

2 a drop down with a choice of Counties come up which match via another
field "yoga"

This is where it's started to fail, it show all of them rather than distinct
ones...

SELECT DISTINCT County FROM DbName WHERE (Description LIKE
'%:escription::%') ORDER BY County ASC

I can no longer get this to work. Have MS changed things in FP2002 in the
most recent updates to cause this to no longer work????

Thanks to anyone who can help with this

M

 

[Mettá]

To get some idea I have a test set up at http://www.metta.org.uk/type1a.asp

the DISTINCT is not on because it does not then show any records in the
first drop down???