Find records with a value in field A OR field B using Filemaker Pro 11

Posted on 2011-03-17
Medium Priority
Last Modified: 2012-05-11
I am trying to create a find that will include all records where either field A OR field B contains a specific value. So far I can only find field A AND field B using the standard find request.
Question by:kwheil
  • 2
  • 2
LVL 25

Accepted Solution

Will Loving earned 2000 total points
ID: 35158706
Assuming you are doing a direct find, all you have to do it create a second "Find Request" and enter the value in field B. To create additional Find requests, just go to File -> New Request or type Control-N (Win) or Command-N (Mac). Creating multiple Find requests gives you the "OR" capability you are looking for.
LVL 25

Expert Comment

by:Will Loving
ID: 35158763
As an additional tip, you can also use multiple Find Requests to find a particular group of records but exclude other records. To do this, create one or more Find requests for what you are looking for. To then exclude some records from the Find results, create additional Find Request, enter the criteria to be excluded and on each of those requests change the "Matching Records:" option in the toolbar from "Include" to "Omit". It's important when using Omit Requests to always put the "Include" Requests first, followed by the "Omit" requests.

Author Closing Comment

ID: 35164464
I wish it was this easy to find in the Filemaker documentation.

Author Comment

ID: 35164467
Thanks for your excellen and timely assistance.

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

A lot of new and distinct gadgets are making their appearance every other day. The latest gadget that has wooed the attention of all gadget lovers and non gadget lovers alike is the Smartwatch. This tiny gadget is capable of offering live access to …
Is your phone running out of space to hold pictures?  This article will show you quick tips on how to solve this problem.
Users will learn how resize a batch of photos from a single command in Photoshop via Photoshop's Image Processor. Open up an Image you'd like to resize in Adobe Photoshop: Adjust the image size according to your preferences. Image > Adjustments > …
CodeTwo Sync for iCloud (http://www.codetwo.com/sync-for-icloud?sts=6554) automatically synchronizes your Outlook 2016, 2013, 2010 or 2007 folders with iCloud folders available via iCloud Control Panel. This lets you automatically sync them with…

624 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question