cxwang

Hi, I am so happy to know that version 6 can do this! Thank you, Bob(I am using Version 5.5). Also, Kennedy, I have implemented your idea and it works, for up to 3 fields now, I am sure the same for 5 fields. I was excited about this before I read Bob's message. Vaughan, thank you for your help, I sent you emails to ask silly questions just to avoid showing my ignorance here and to get instance response. Did you say that we can get a free upgrade to 6.0 through ITD ?

Thanks again for the good ideas, I would like to have a generic solution, thus will try the way Kennedy suggested: adding a "Mark" field. I will keep you posted. More comments and suggestions?

Thank you for the response, LiveOak and Kennedy. What I am trying to do is avoid the conversion, as totally there are 7 states, 4 grades, about 10 professions... (or I need a program to do the conversion) Can I do "OR" first, save the found set, and then do "AND" ? If someone can definitely tell me this is a task FileMaker Pro can not do, I 'll drop this idea, otherwise I am obsessed with it.

Hi, I need to add advanced search features in FMP, for example, there are 5 fields I want to put search criteria, there are "AND" and "OR" in each field. Field1: State Field2: Sex Field3: Grade Field4: Membership Field5: Profession I use checkboxes to display all the possible choices for each field. How do I make a script to search for people satisfying, say, the following criteria: From State 1 OR State 2 OR State 3, AND Male, AND In Grade 1 OR Grade 2, AND Member OR nonmember, AND Civil Engineer OR Architects I know how to use script to search multiple selections for a single field (counting the carriage return signs between the checkbox selections...), but don't know how to combine it with more search field. Can I save a found set and then do find on top of this subset? Any help greatly appreciated!