EXAMPLE: Omit In A Multiple Request Search

From Dwayne Wright
Certified FileMaker 9 Developer
www.dwaynewright.com
info@dwaynewright.com

This is a very simple example of a multiple find with an omit option. Lets say that you want to find records about students grades 3 to 5, but you want to omit the students from an specific school.


1) Enter find mode ( we provided a button to make it easier for you ) and type the grade range (3...5) in your grade field.

2) Create new second find request ( we provided a button to make it easier for you ) and select the name of the school you wish to omit.

3) Click the Omit checkbox in the status area. There isn’t a way for use to script this action they way we are walking you through this and I wanted you to click the omit box for demonstration purposes. You can save an omit operation in a script, in fact, there are multiple options for that.

4) Perform the find by hitting the enter key on your keyboard, the Find button in the status area or the button we provided.

This search finds all records with the grades you specified then omitted any record with the school name you specified on the second find request.

We added a show omitted button so that you can toggle the views of the found set of records.

An example file can be downloaded at ...
http://www.dwaynewright.com/blogfiles08/simpleomit.zip

Here are some links to other posts that might be of interest in regards to this topic...
The Status Area In Find Mode
Omit Multiple Command
Adding Omit To Searches
EXAMPLE: I Don’t Want To Find
EXAMPLE: Found Set Flipping
Omit Command
EXAMPLE: Multiple Find Requests
Found Set
Constrain Found Set
The Show Omitted Script Step
The Omit Script Step
The Omit Multiple Script Step
Controlling The Found Set Of Records
EXAMPLE: Constrain Sans The Find
The Get(RequestOmitState) Function
New Record / Request Script Step
Omitting Records From The Found Set
=
More info about the author and FileMaker in general, contact me at info@dwaynewright.com.

© 2008 - Dwayne Wright - dwaynewright.com

The material on this document is offered AS IS. There is NO REPRESENTATION OR WARRANTY, expressed or implied, nor does any other contributor to this document. WARRANTIES OF MERCHANT ABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE EXPRESSLY DISCLAIMED. Consequential and incidental damages are expressly excluded. FileMaker Pro is the registered trademark of FileMaker Inc.

====================== ADVERTISEMENT ==============================
Click Here To See The FileMaker Book (via a blog) homepage!
===================================================================