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?