...that is how to implement that DISTINCT ROW parameter. The problem is, that I made a dynamic menu, where I want values from a DB field. But it, certainly, returned ALL of the records, which creates a very long (and useless) list. How could I tell the CF server that I only need ONE INSTANCE of every value? SQL reference is DISTINCT ROW.

Thank you guys in advance,
Kutt.

Less is more1

You seem to have answered your own question, set up the recordset used for the Dynamic list/menu with and SQL statement something like:

SELECT DISTINCT FieldName FROM TableName

Regards

Owen.

Multiple Parameter UD4 / Access 2000 Database Search Tutorial:
www.tdsf.co.uk/tdsfdemo

Hmm...I knew I was close <img src=../images/dmxzone/forum/icon_smile_cool.gif border=0 align=middle>

Thanks.

Less is more1