I have deleted all constraints from my database tables in order to alleviate some issues with an SSIS solution I am using. Because of this when I updated my .rlinq file from the database all of my constraints were removed (as expected).
I now want to add them back only to the object mapper. However, I am running into a problem where the field that I need to use as a foreign key is not
included in the correct
drop down list of fields. There seems to be something happening behind the scenes that is trying to auto-assign the relationships. Why is this, and how can I get around it?
Constraint Editor Screen Shot
From this screen shot you can see that the "Constraint Editor" is trying to assume certain connections. This would be fine if because "PatientID" exists in the second drop down list under the "Source Table" that it is excluded from the first drop down list, making it impossible to associate "PatientID" with the "ID" field (which cannot be changed in the form) under the "Target Table".
So to wrap all of that up...
All I need to do is associate "PatientID" (Source Table) with "ID" (Target Table). Am I missing something obvious here?