Tech Tip: String Formats and Relations
PRODUCT: 4D | VERSION: 13.5 | PLATFORM: Mac & Win
Published On: August 18, 2014
When activating UUID format for an Alpha Field it changes the Type of the Field from a Varchar to UUID. Thus when trying to create a relationship between two fields of seemingly Alpha Fields, the types must match or the relationship will not be created.

Table_A's Field_1 is an Alpha Field with a VARCHAR Typing

Table_B's Field_2 is an Alpha Field with a UUID Typing

When a Relationship is attempted to be created the mouse cursor displays rejection symbol and upon release nothing is created.
Thus when using Alpha fields and relationships remember to have both fields set to the same type, UUID or Varchar.

Table_A's Field_1 is an Alpha Field with a VARCHAR Typing

Table_B's Field_2 is an Alpha Field with a UUID Typing

When a Relationship is attempted to be created the mouse cursor displays rejection symbol and upon release nothing is created.
Thus when using Alpha fields and relationships remember to have both fields set to the same type, UUID or Varchar.