telosystools

Open full view…

Generation errors when FK field name differs from related PK

pkesel
Fri, 03 Jun 2016 12:50:01 GMT

I'm generating a repository from an old database where the name of a foreign key column in a table differs from the name of the primary key in the related table. For example my Communications table column 'FulfillmentTypeCode' relates to the FullfillmentType table primary key column 'Code'. I get an exception and a message saying, "No referenced table for Foreign Key . . .". Is there any way around this?