Witango's search action is pretty good at interpreting your intentions. You can do AND sub groups within OR by
Table.column1 = blah And Table.column2 = blah Or Table.column1 = hoo And Table.column2 = hum Notice that I have drag column1 and column 2 in twice. The search action will create the following in SQL. (column1 = 'blah' and column2 = 'blah') or (column1 = 'hoo' and column2 = 'hum') Ben Johansen - http://www.pcforge.com Authorized Witango Reseller http://www.pcforge.com/WitangoGoodies.htm Latest downloads & List Archives @ http://www.witango.ws -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Fogelson, Steve Sent: Thursday, June 13, 2002 1:15 PM To: Multiple recipients of list witango-talk Subject: Witango-Talk: Search Action Probably a easy dumb question. I want to do a search action as follows: A=True and B=True or A=True and C=True and D=True Can the Search builder indicate A=True and B=True or C=True and D=True or does it have to be A=True and B=True or A=True and C=True and D=True Thanks Steve Fogelson Internet Commerce Solutions ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body