I am trying to set the filter on a formatted search. So if I type something and then pull up the formatted search the filter only pulls in results with the first few letters typed. Also it is possible to return the first field but search based on the criteria in the second or third field by default??
you could check the field for a value using the $ dereference.
If you find a value you can execute a sql query with the term like in the where clause
ie where cardcode like $[ORDR.Cardcode]
then if you don't find a value in the dereferenced field don't use like.
if $[ORDR.Cardcode] = '' begin
select ... where cardcode like $[ORDR.Cardcode]
i don't know if it works- u need to try it....