2 Replies Latest reply on Jun 12, 2012 2:06 PM by davidanders

    Omit and include in the same find

    PeterMontague

      Title

      Omit and include in the same find

      Post

      Is it possible to omit in one field and include in another field in the same find? When I attempt it I can only include or omit but not both. I know that i can do an or find and get broader results. But sometimes i look for narrower results. Is there a workaround?

        • 1. Re: Omit and include in the same find
          philmodjunk

          It's the same setup as an "or", but make sure that "omits" are listed last.

          Enter find mode

          specify the matching criteria

          create a new request

          Specify the omit criteria in the new request

          Click the Omit button or (in the script use omit record) to make it an omit request

          • 2. Re: Omit and include in the same find
            davidanders

            http://help.filemaker.com/app/answers/detail/a_id/5210/~/multiple-find-requests

            Multiple Find Requests      Updated: Oct 20, 2011

            Some FileMaker Pro owners may be familiar with database programs that require you to enter search requests using "and/or" logic. If you are trying to understand how to apply these techniques to FileMaker Pro, here are some guidelines to keep in mind:

            • The Add New Request command lets you have more than one find request at a time. Add New Request shows up when you are in Find Mode and can be found under the Requests Menu. Multiple Find requests behave as "or" criteria. For example, suppose you have a database that contains a State field and you want to find all the records that contain "California" or "Hawaii."

            1. Enter Find Mode.

            2. Type "California" into the State field.

            3. Select New Request from the appropriate menu.

            4. Type "Hawaii" into the State field.

            5. Perform the Find.

            • To make an "and" request, you must list multiple criteria in the same request. For example, suppose you wish to find all records that contain "California" in the State field and "Smith" in the LastName field.

            1. Enter Find Mode.

            2. Type "California" into the State field.

            3. Type "Smith" into the LastName field.

            4. Perform the Find.

            • You can combine the "and" and "or" requests as well. For example, suppose you wish to find all the people in California with the last names of "Smith", "Jones" or "Brown".

            1. Enter Find Mode.

            2. Type "California" into the State field.

            3. Type "Smith" into the LastName field.

            4. Select Duplicate Request from the appropriate menu.

            5. Change "Smith" to "Jones".

            6. Repeat step 4 and change "Jones" to "Brown".

            7. Perform the Find

            • Omit requests are neither "and" nor "or" equivalents. They act on the set of records that would be in the found set based on the Find criteria preceding the Omit request. As such, Omit requests should always be the last of all requests. For example, suppose you wish to find all the people in "California" with the last name of "Smith" but not "Jane" "Smith".

            1. Enter Find Mode.

            2. Type "California" into the State field.

            3. Type "Smith" into the LastName field.

            4. Select Duplicate Request from the appropriate menu.

            5. Check the Omit box on your status bar.

            6. Type "Jane" into the FirstName field.

            7. Perform the Find.