Relationship Property Sheet Joins Tab (LDM)

A join is a link between an attribute in a parent entity and an attribute in a child entity (attribute pair) that is defined within a relationship.

A join can link primary, alternate or foreign identifiers, or user-specified attributes in the parent and child entities that are independent of identifier attributes.

Linking Attributes in a Primary or Alternate Identifier

For any relationship you can choose to link a primary or alternate identifier, to a corresponding foreign identifier. When you select an identifier from the Joins tab of the relationship property sheet, all the identifier attributes are linked to matching foreign identifier attributes in the child entity.

Note:

A foreign identifier attribute can be changed to link to another parent entity attribute, either within the identifier relationship, or independent of it.

Reuse and Migration Option for a Selected Relationship

You can use the following buttons on the Joins tab to reuse or migrate attributes linked by joins.

Tool	Description
	Reuse Attributes - Reuse existing child attributes with same code as parent entity attributes.
	Migrate Attributes - Migrate identifier attributes to foreign identifier attributes. If attributes do not exist they are created.
	Cancel Migration - Delete any migrated attributes in child entity.