Working with related tables > About relationship criteria > Relationships that use comparative operators
 
Relationships that use comparative operators
In a comparative relationship, you use one or more of the following operators to compare match field values in the two related tables. The relationship returns related records when the comparison evaluates successfully according to the criteria you establish.
 
Relational operator
Matches these records
=
Values in match fields are equal
Values in match fields are unequal
<
Values in the left match field are less than values in the right match field
Values in the left match field are less than or equal to values in the right match field
>
Values in the left match field are greater than values in the right match field
Values in the left match field are greater than or equal to values in the right match field
x
All records in the left table are matched to all records in the right table, regardless of the values in the match fields (sometimes called a Cartesian product relationship)
For example:
Two tables with lines between two fields showing a relationship based on the greater than comparative operator
This relationship is defined with the following criteria:
 
Table
Field name
Comment
TableC
DateFieldC
Match field to DateFieldD; records in TableD are related to records in TableC that have a later DateFieldC value
TableD
DateFieldD
Match field to DateFieldC; records in TableC are related to records in TableD that have an earlier DateFieldD value
If a record in TableC has a DateFieldC value of 12/11/2019, all the records in TableD with a DateFieldD value of 12/10/2019 or earlier are related to it. In TableD, if a record has a DateFieldD value of 12/11/2019, all records in TableC with DateFieldC values of 12/12/2019 or later are related to it.
Related topics 
Working with the relationships graph
Creating and changing relationships
Creating portals to display related records