Export from ERD to SQL - relationships incorrect


I'm exporting an ERD to SQL Server. The diagram consists of one entity with relationships to three other tables. Looking at the generated SQL, the foreign keys are set up incorrectly. A FK that references table A, for example, uses the column that is the foreign key to table B.

Am I doing something wrong? Any way to fix this other than manually edit the generated SQL each time I export?



I found the problem. The relationships need to be connected to the corresponding table at the connection points for the corresponding columns. 

Issue resolved.

Abigail M
Lucid Manager

Hi Paul, thanks for following up with that resolution! If anyone else is experiencing issues with ERD > SQL export, feel free to post your question in this thread.