Duplicate A FileMaker Current Found Set Using Omit [example]

From Dwayne Wright PMP
Certified FileMaker Developer

WEB: www.dwaynewright.com
EMAIL: info@dwaynewright.com
TWITTER: dwaynewright
YOUTUBE: FileMakerThoughts

Please Note: If you are viewing this page in a news feeder, the images may get munged up a bit or other formatting of the posting may fail. For the best experience, please visit the journal directly by clicking (here)

It is not uncommon for a database to store very similar information at different dates. You get an entire set of bills each month that are basically the same thing as last month. This technique has the ability to duplicate a found set of records. It is a single file solution that uses a loop script. We added a couple find buttons to allow you to come up with a found set easily.

So what you will want to do is click the button to do a find for Illinois records. Take a look at the found set you have and then click the Duplicate Found Set button. You will see that you have more records overall. Click the button to Find Illinois again and you will see the found set has indeed be duplicated.

Here is a look at the script that performs the duplicate found set action. It is a looping script that will go from record to record in the found set and duplicate it (if it has not been duplicated already).

An example file can be downloaded by clicking ( here ).

=
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.