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