Relationship operators: =, ≠, <, >, ≤, ≥, and range

Intermediate

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

1/3

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

FileMaker Script

# 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

The Cartesian product (×) relationship operator Primary keys and foreign keys: UUID vs serial number