I have a parent view with column named:
I have a child view that I named a column:
The driver then spits back:
Invalid identifier 'FK_PERSON_ID'. Foreign key missing required referenced column name.
I tried changing the child views column to:
Then the driver spits back:
Column 'FK_PK_PERSON_ID' has mutually exclusive constraints foreign key (fk) and primary key (pk).
I seem to get no errors if I name the child view column:
The parent view would be:
The child view is:
Where the person can have multiple email + email_code combinations.
I guess I don't understand constraints well enough to decipher.
Thanks again in advance!