Understanding Your Data Model › Using Relations › Examples of Using For Text

Examples of Using For Text

You have two entities defined, Customer and Order. The Order is placed by one Customer but can be paid for by a different Customer. The Order needs to have two references to the Customer entity to define the two Customers, one for ordering and one for invoicing.

To clarify which Refers to relation is for invoicing Customer and which is for ordering Customer, use For text.

FIL   Customer        REF     Known by        FLD     Customer code   CDE

FIL  Customer        REF     Has             FLD     Customer name   TXT

FIL  Order   REF     Known by        FLD     Order code      CDE

FIL  Order   REF     Refers to       FIL     Customer                        TXT

       For: Ordering                   Sharing: *ALL

FIL  Order   REF     Refers to       FIL     Customer                        REF

               For: Invoicing                  Sharing: *ALL

The resolved entries for the two entities will be:

Note that when a file A Refers to a file B more than once, the For text is applied only to the second and subsequent Refers to relations. To change the first relation, type R (replace field) against the first relation on the Edit Field Entries panel and define a new referenced field on the Display Referenced Field Details panel with the For text appended; in our example, Ordering Customer code. The resolved entries for the Order file would then be: