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.