LLBLGen Pro 3.1 Final
SQL Server 2010
Tables:
ActionPlan:
ActionPlanID int PK
QuestionResultID int FK
...
QuestionResult:
AuditResultGlobalID GUID PK
QuestionResultGlobalID GUID PK
DuplicateID int PK
QuestionResultID int UNIQUE
...
The ActionPlan table has a FK relation to the QuestionResult table using the unique column QuestionResultID. QuestionResultID is not the Primary Key of the QuestionResult table, but it is a unique column.
For some reason the designer isn't picking up the relationship. Is this supported or do all Foreign Keys have to be pointing to the Primary Key field of the referenced table?