FK not showing on diagram in the model - why?
FK columns are not showing on a Diagram display in the model, even though there is a Relationship between the Parent and Child Tables. Why?
On the Subject Area, Go to Diagram | Diagrams... Launch Diagram Editor windows, Tab Entity, checkbox on "Display Logical Foreign Key (FK) Designator" and Display Migrated Attributes. If this is a physical model, go to Tab Table and check "Display Physical Foreign Key (FK) Designator" . Also, if the FKs are not showing in physical side, then make sure that the Parent Table, Child Table and Relationship between them is not marked as 'Logical Only'. Conversely, if they are not showing in the logical side, then make sure the same is not marked as 'Physical Only'.