Relationships that return a range of records

A relationship that returns a range of records is similar to a multicriteria relationship, except that you use comparative operators to find records that are greater than one of your criteria and less than your other criteria. This type of relationship is commonly used to return records that fall between a range of dates or serial numbers.

For example, from within TableE you would like to view all the records in TableF that have DateFieldF values that are greater than StartingDateE and less than EndingDateE.

In the relationships graph, the Multicriteria indicator symbol indicates that different relational operators are being used in this relationship.

Two tables with lines between two fields showing a relationship that will return a range of records

Section of edit relationship dialog box showing multicriteria relationship using comparative operators

This relationship returns records from TableF that have a DateFieldF value that is later than StartingDateE and earlier than EndingDateE.

For example, when the StartingDateE value is 11/01/2019 and the EndingDateE value is 12/01/2019, the relationship returns related records with the following values.

DateFieldF

TextFieldF

11/14/2019

blue

11/27/2019

green

When the StartingDateE value is 12/01/2019 and the EndingDateE value is 01/01/2020, the relationship returns related records with the following values.

DateFieldF

TextFieldF

12/02/2019

red

12/15/2019

yellow

12/17/2019

orange

12/26/2019

brown