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

The Leading Filemaker Developer Tools

The Unequal (non equijoin) Comparison Relationship In FileMaker – FileMaker Today

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

The official term is non equijoin but unequal sounds a little more descriptive to me. In FileMaker, the define relationship dialog box got a nice boost. You can have a choice of operators other than equal to … for example you can have …

≠ ( not equal )

> ( greater than )

< ( less than )

≥ ( greater than or equal to )

≤ ( less than or equal to )

x ( means all records in both table occurrence compare, no matter the data in either )

The Unequal (non equijoin) Comparison Relationship In FileMaker

FileMaker allows you to create relationships that comprise of more than one comparison layer. This can be very handy when building date range related comparison using the new greater than and less than operators. Say you have two global date fields, one called start date and one called end date. One layer of the relationship could be greater than start date and that would normally return a set of related records. Add to this a second layer of less than end date and you have a range of related records!

You could add yet another layer that could say, day ≠ ( not equal ) Saturday and add another layer to say day ≠ ( not equal ) Sunday … and … the returning related records would be week days!

The Unequal (non equijoin) Comparison Relationship In FileMaker Here is an example of a multiple layer compare in action!


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