Maximum Records

Mandatory.

The maximum number of records that are expected to be found in the Accessed Table that have a key matching the Key Columns/Values specified.

If the value is One then a "1:1" relationship between the tables is established. If the value is More than one, then a "1:many" relationship is established. The relationship between the tables affects the method by which screen formats are designed. It determines the type of PJCs that can be created. (Refer to Access Routes and PJCs in the Developer Guide.)

Rules

Allowable values are:

Platform Considerations

Also See

Keep Last

Key Columns/Values

Predeterfmined Join Column Development in the Developer Guide.