Powerful Relationships

Version 2




    Mac OS X, Windows
    Todd Duell
    FMP 7, 8, 8.5, 9, 10, 11
    Formulations Pro
    Web: No
    File Type: FP7
    Server: Yes
    FileSize: ~ 1.16 megabytes


    FileMaker 7’s new relationship model can be summed up with one word: awesome! The potential for managing data and business rules is absolutely endless now that you can choose how the data between fields are related (=, >, ≥, <, ≤, ≠, x) as well as the ability to create complex relationship criteria using additional matching fields (AND unions). Relationships can now be used to handle communication in both directions. That means no more duplicate relationships using the primary and foreign keys. Lastly, if you prefer to visualize your ER (entity-relationship) diagram you can view the structure of your solution and drag-and-drop fields between tables to create a basic relationship. I’d say the only thing left is for FileMaker to allow the use of dynamic field variables for the relationship operator, more unions, and the ability to apply calculations to the fields. That would eliminate the need for any of the remaining calculation tricks. This article will discuss four examples and use all the elements of the new relationships model. A demo database is available for download at www.formulationspro.com so you can follow the article and study how this new relationship model works.


    See sample file


    Sample Input

    Sample Output

    Developer's Notes

    See sample file for full demo and technical article.


    FileMaker Inc. provides this content on an “As Is” basis, without any warranty, and subject to the terms of the FileMaker Technical Network Agreement. FileMaker makes no representations and is not liable for any content or related information. You may use the content as part of your own solutions and for your customers, but you may not otherwise publicly distribute any content that you did not submit. ©2009-2011 FileMaker, Inc. All Rights Reserved. FileMaker is a trademark of FileMaker, Inc. registered in the U.S. and other countries.