Is there one? I can't find it..

What I want to know is how to use a filtered recordset when using the database generated entries option, it is useless to me if I have no control over which records get listed.

Also what does " From all " mean in the Suggestion Options ? It doesn't seem to do anything.

Thanks,

John

UPDATE

actually I've found where the select statement is on the autocomplete.php and amended it to include my query which now works fine - but what I would also like to do is have the script check a combined field made up from two - (it's finding a name and I have firstname and surname fields) - the From All does work now but I need the optional field for a descriptor so can't put the surname there (and it doesn't highlight anyway <img src=../images/dmxzone/forum/icon_smile_sad.gif border=0 align=middle> )

Any suggestions?


UPDATED UPDATE

Given up and have gone over to asp/access so I can use a query to filter and concenate my fields - but I still have one thing I need - how do I pass my optional field along with the primary field when I submit my form - there must be a simple fix, right?



Edited by - webbyfoot on 08 Jan 2008 00:19:35