Understanding Your Data Model › Using Relations › For Text

For Text

You can add a For text clause to a relation statement to further clarify the description of a relationship. Owned by and Refers to are the only relations that can use For text.

To extend a relation, type a + in the selection field beside the Owned by or Refers to relation and press F5.

The For text helps document the meaning of a relation. The For text is also used to identify file entries that may be duplicates of existing file entries based on a previously defined relationship.

If a given file refers to another file more than once, the For parameter can be used to distinguish between each reference.

CA 2E files cannot contain duplicate fields. To prevent duplicate fields from being added to a file from the resolution of the Owned by and Refers to relations, CA 2E uses the following procedure:

• If the new entry arises from a relation that has For text, CA 2E uses the For text and the entry name to define the new field.

  Example: If Company code is the entry that arises from a relation that has Invoice in its For text, the new field will be Invoice Company code, with a REF field type, referencing Company code.

• CA 2E then checks the field dictionary to determine whether Invoice Company code exists. If it does, CA 2E uses the field. If it does not, creates the Invoice Company code as a new field to be added to the file, referencing the existing field (Company code).
• If the new entry arises from a relation without For text,CA 2E uses the entry name and a surrogate number to define the new field. The surrogate number is added as part of the entry name.

Example: If Company code is the new entry, the new field may be Company code 25642.

The new field has a field type of REF, referencing the existing field (Company code).

You may override this processing and modify the names of fields by using the Display Referenced Field Details panel.