Rolename in foreign key column

[KimTessereau]

Can you have a different name for a column in a child table than the name on the primary key column it’s coming from?

[frahuang]

Yes, see the attached picture. The PK in Entity1(parent) is Attribute1 but the FK in Entity2(child) is Attribute5.

[cid:image001.png@01CB6C4F.6EFA8880]

[KimTessereau]

So I build the relationship first and then go into the column editor and change the name?

[dkretek]

Hi Kim,
you can also rename the FK name in the child table. Please see the attached screen shot.

Regards,
Dave

[KimTessereau]

Thanks Dave!