I have a parent view with column named:
pk_person_id

I have a child view that I named a column:
fk_person_id

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:
fk_pk_person_id

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:
pk_person_id

The parent view would be:
person_id
lastname
firstname

The child view is:
person_id
email_code
email

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!