The Original FileMaker Community
Business Templates - Demo Apps - Video Tutorials -Samples - Help - 46000 Member Forum

The Leading Filemaker Developer Tools

FileMaker Relationships That Range – FileMaker Today

Get real time updates directly on you device, subscribe now.

A range relationship basically means that a starting value is determined ( either by data entry or via a calculation ) and an ending value is determined ( again either by data entry or a calculation ). FileMaker adds a new level to ranged relationships with the new comparison operators and multiple levels of matching criteria. Ranges can be built on almost any type of data but date range would likely be the most common. You will also see ranging relationships for numbers, time and even text. The matching records of a relationship range can be displayed in a portal or used to build a found set by using the GTRR command.

FileMaker Relationships That Range Here you can see that the FileMaker child key data has two layers. The appointment date needs to be greater than then start date and less than the end date. You can see how multiple layers are very handy for relationships that range.


More info about the author and FileMaker in general, contact me at This email address is being protected from spambots. You need JavaScript enabled to view it..


This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. Accept Read More