NightWing Enterprises - FileMaker Pro Custom Development

+   Home    About Us    Products    Demos    Resources    FAQs    Orders    Contact   +


NightWing Enterprises -- FMP8 demos 848!

+   Showcasing FileMaker 8!   +

As a courtesy to fellow developers and potential clients, the
following demonstration is provided for free download.

NB: If you may require assistance implementing procedures such as those shown in the
example files, please consider establishing an account with us for developer support.

Finding only one of each record when there are duplicates!

Omitting duplicate records is something that is frequently required, but the best known techniques involve using a script to mark records and then omitting them - and that can produce unpredictable results in multi-user mode (eg if more than one user is running the script at once).

One of our most frequently downloaded demos for FileMaker 5/6 was a file that solved this problem. It's still available in our archive. However all good things get better, and we're now pleased to offer you an even cleaner, simpler faster and more robust technique for eliminating duplicates - using the powerful new capabilties of FileMaker 8. This implementation is tuned for moderate sized data sets, but the principles used can be extended to larger applications if required. The solution demonstrated in this example file provides a new and efficient method by which duplicate (second or subsequent) copies of a record can be omitted by script without any record marking, based on the contents of a designated field. In the demo implementation, the field which will be checked for duplicates can be selected. Of course - with the addition of a couple of steps - the demonstrated technique can also be used to locate and remove any duplicate entries!

This is a FileMaker 8-only technique - it won't run in earlier versions. The file contains no passwords. Examine it at your leisure. To download a Mac archive in Stuffit format click on the MacOS icon at right, or for a download in PKzip format, click the Windows icon.

  Mac OS X demo download

Win XP demo download



Find Unique Demo




NightWing Enterprises
ABN 22 207 533 285
PO Box 20, Dallas, Victoria, Australia 3047
Ph +61 3 9309 1434  •   Fax +61 3 9309 8273  •   Mobile 0409 309 143

+   Home    About Us    Products    Demos    Resources    FAQs    Orders    Contact   +

© 2001 - 2011 NightWing Enterprises
Please report any problems with this site to:  

NightWing Enterprises - FileMaker Solutions:- NightWing Enterprises, and the internet code-named CobaltSky is an internationally recognized Filemaker consultant, Filemaker developer and provider of Filemaker pro custom databases, Filemaker pro custom development, Filemaker pro custom programmer services and Filemaker pro custom programming.
Site created and managed using FileMaker™ Pro.