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 symbol indicates that different relational operators are being used in this relationship.
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 |