Add Relationship

All entities: Matches with any entity.
Compare entity names: Enables adding and removing of prefixes and suffixes fields to compare equality of entity names.

Creates relationships between the matched attribute pairs in the matched entity pairs.

Label	Description
Match for PK attribute	Select the criteria for finding the matching PK entities.
Match for FK attribute	Select the criteria for finding the matching FK attributes.
Matching style	How to join the FK and PK entities: All entities: Matches with any entity. Compare entity names: Enables adding and removing of prefixes and suffixes fields to compare equality of entity names.
Match PK entries by removing	Enter the Prefix and Suffix to remove when matching PK entries.
Match PK entries by adding	Enter the Prefix and Suffix to add when matching PK entries.
Match FK entries by removing	Enter the Prefix and Suffix to remove when matching FK entries.
Match FK entries by adding	Enter the Prefix and Suffix to add when matching FK entries.
Join on	How to join attributes: Attribute name: Use the name of the attribute. Attribute label: Use the label of the attribute. Custom: Use template code to compare the matched attributes. The joining of the attribute name or label is case sensitive.
Allow self-referencing	Indicates whether to allow creation of relationships that have attributes in an entity reference another attribute within the same entity.
Assign to relationship	Assign relationship types to relationships. Note The rule only applies one of the relationship types, if the category settings has 'Limit relationship types' is enabled.