The Select Fields from Source File screen is displayed as:

• The first step to reviewing Predetermined Join Fields

• The first step to changing Predetermined Join Fields

  DC@P200903         Select Fields from Source File                                                                                               Access Route: XXXXXXXXXX   XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX  (XXXX )  Source File:  XXXXXXXXXX   XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX                                                                                   Select   Source field to define Predetermined Join Fields                                                                                        Sel   Field       Description                         Type Len Dec       _    XXXXXXXXXX  XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX  X   999  9        _    XXXXXXXXXX  XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX  X   999  9        _    XXXXXXXXXX  XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX  X   999  9        _    XXXXXXXXXX  XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX  X   999  9                                                                                                                                                      Fnn=Help  Fnn=Exit  Fnn=Cancel  Fnn=Messages

   |
  Working from this screen you can:
  Select a field from the accessed file for review/change/create or deletion of Predetermined Join Fields. To do this enter any non-blank character in the column labeled "Sel" against the required field. The resulting display will depend on the relationship defined on the access route and the type of field selected.

• If the relationship is 1 to 1, only the LOOK UP operation is performed.
• If the relationship is 1 to many and the selected field is alpha only, the COUNT operation can be performed.
• If the relationship is 1 to many and the field selected is numeric, TOTAL, MAXIMUM, MINIMUM, AVERAGE and COUNT can be performed on it.