Relationship operators: =, ≠, <, >, ≤, ≥, and range
IntermediateGo beyond the default equality operator to build range-based and inequality relationships that return records matching a condition rather than an exact key match.
What you'll learn
- Which comparison operators are available in Edit Relationship
- How to build a date-range or value-threshold relationship
- How to combine multiple criteria within one relationship for compound conditions
FileMaker relationships are not limited to equality — you can use comparison operators to relate records based on ranges, thresholds, and inequalities.
Stuck is a valid status
Need a second brain on this one?
If this lesson just collided with your real schema, script stack, or deadline, book consulting and turn the confusion into a concrete plan.
Select a comparison operator in Edit Relationship
In the Edit Relationship dialog, click the operator symbol between the two field columns. Options are: = (equal), ≠ (not equal), < (less than), > (greater than), ≤ (less than or equal), ≥ (greater than or equal), and × (Cartesian).
# Examples of non-equality relationships: Budgets::MaxAmount ≥ Expenses::Amount # Returns all Expenses records where Amount ≤ the current Budget's MaxAmount Employees::HireDate ≤ Get(CurrentDate) # Not valid — you cannot use a function; both sides must be fields # Use a global field instead: Globals::gToday ≥ Employees::HireDate # Returns Employees hired on or before today
Sign in to track your progress and pick up where you left off.
Sign in to FM Dojo