topic Relationship Class properties show Foreign Ley for Origin Table, not Destination in Data Management Questions

Relationship Class properties show Foreign Ley for Origin Table, not Destination

Anonymous User — Tue, 10 Sep 2013 20:44:31 GMT

Original User: dgoldb2@luc.edu

I'm confused here. The foreign key is not a field in the origin table, it is the primary key in the origin table that references the FK in the destination table.
Am I doing something wrong or are my relationship classes good?

Also, this doesn't seem to create a foreign key constraint in the db. Do I have to write ALTER sql to get those?

Re: Relationship Class properties show Foreign Ley for Origin Table, not Destination

Anonymous User — Mon, 16 Sep 2013 17:14:03 GMT

Original User: dgoldb2@luc.edu

I resolved this with tech support.

The second dropdown is labeled Origin Foreign Key, which is what threw me off. It is simply the field to which the PK refers.

Foreign Key constraints ARE enforced by the relationship class, as described in the second paragraph of the Simple vs. Composite section of this page

I hope that helps.