Or with filter I setup a stack with a list field and 4 search fields, 1 search field for each column, and added a search button.
--Search button code on mouseUp put field "mylist" into tMyList repeat with i = 1 to 4 if field ("field" & i) is empty then put "*" into line i of tMerge else put field ("field" & i) into line i of tMerge end if end repeat filter tmyList with (merge("[[line 1 of tMerge]][[tab]][[line 2 of tMerge]][[tab]][[line 3 of tMerge]][[tab]][[line 4 of tMerge]]")) put tMyList end mouseUp Puts an asterisk for empty search fields puts the value for the fields that should be matched against. _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode