Solved

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

Posted on 2011-03-17
4
550 Views
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.
0
Comment
Question by:kwheil
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 25

Accepted Solution

by:
Will Loving earned 500 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.
0
 
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.
0
 

Author Closing Comment

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

Author Comment

by:kwheil
ID: 35164467
Thanks for your excellen and timely assistance.
0

Featured Post

Enroll in June's Course of the Month

June’s Course of the Month is now available! Experts Exchange’s Premium Members, Team Accounts, and Qualified Experts have access to a complimentary course each month as part of their membership—an extra way to sharpen your skills and increase training.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Package creation on OS X uses the PackageMaker utility installed as part of the XCode development suite ( on the OSX Client CD).  Packages can be installed as part of the machine build process, or later using Apple Remote Desktop. They are generally…
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 …
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…

717 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