Create Foreign Key in ERD
553470Dec 26 2006 — edited Jan 2 2007I have a relationship between two tables where TableA.fkcolumn should have a foreign key constraint from TableB.fkcolumn. I create a Many-to-One relationship in ERD from TableA to TableB. When I do the Design Transformation, however, the Table Definitions created (browsed in RON) has an extra column in TableA which has a foreign key constraint to TableB but TableA.fkcolumn doesn't have the foreign key constraint.
My question: how can one create a foreign key relationship between two tables using ERD? Also, how can we create such a relationship in RON but in Entities and not in Table Definitions?