Parameter passing across records

Parameter passing allows you to define a relationship between two fields that are not directly connected by a relationship, but instead are linked together through a series of records that have relationships defined between them.

In a typical relation between records in a Business Record diagram, a relationship is defined between a master record and its child record, and the parameter passed is defined in the whereParameters property.

Advanced parameter passing takes this further, allowing you to specify parameters that will pass through one or more records in a relationship chain.

Advanced parameter passing works only if the following is true:
  • You must have specified the proper fetch order of the records. The record containing the field defined by the value of the parameter (typically the primary key) must be fetched prior to the record containing the parameter field (typically the foreign key). See Order records in the Business Records diagram.
  • You must have specified proper settings for the occurrences property. Advanced parameter passing will only work if the occurrences property is set to either "0 or 1" or "1" on the relationships between the involved records. Failure to meet this criteria will result in a pair of error messages: the first where the error occurs, the second locating the source of the error.