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

571
1
09-10-2013 01:44 PM
by Anonymous User
Not applicable
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?
0 Kudos
1 Reply
by Anonymous User
Not applicable
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.
0 Kudos