Relationships and Domains › Relationships in the Logical Model › Migrate an Alternate Key as a Foreign Key

Migrate an Alternate Key as a Foreign Key

Primary key attributes or columns automatically migrate from a parent to child entity or table when you connect them using a relationship. You can specify, for an individual relationship, that the alternate key attributes or columns migrate to the child entity or table as a foreign key instead of the primary key attributes or columns.

To migrate an alternate key as a foreign key

1. Click Relationships on the Model menu.

   The Relationships editor opens.

2. Click the Rolename tab.

   The Rolename tab opens.

3. Select the alternate key to migrate as a foreign key in the Migrated Key list, optionally assign a rolename, then click OK.

   The alternate key is migrated as a foreign key and the Relationships editor closes.

More information:

Assign a Rolename to an Attribute

Alternate Key Migration