Field that Can Be Specified for the "Fetch criteria" Setting in Related Records

Article Number:040551

Combinations of fields that can be specified for Fetch criteria in the Related records field differs depending on the field type.
If you specify a field in Field in this app (the dropdown on the left), fields that can be combined with the specified field are displayed in Field in datasource app (the dropdown on the right).
Screenshot: The settings for a "Related records" field are displayed
Refer to the following table for the combination of fields that can be specified.

Field in this app Field in datasource app
  • Text
  • Lookup: The Key field is a Text field
  • Text
  • Link
  • Lookup: The Key field is a Text field
  • Number
  • Calculated
  • Lookup: The Key field is a Number or Calculated field
  • Number
  • Calculated
  • Record number
  • Lookup: The Key field is a Number, Calculated, or Record number field
  • Link
  • Lookup: The Key field is a Link field
  • Link
  • Lookup: The Key field is a Link field
Note: When setting a Link field, you must match the Type.
  • Record number
  • Lookup: The Key field is a Record number field
  • Number
  • Calculated
  • Lookup: The Key field is a Number, Calculated, or Record number field