Hi there,

In one of my tables I have 3 foreign keys who needs to form the primary key. Only problem is that one of those foreign keys does not have to be filled. But doing so I get an error, telling me that a primary key cannot contain any nullables.

Does anyone have a solution ??

Thanks in advance,
Dennis

You need to refer PK definition, PK means not nullable and unique,
if your one of your 3 FKs is nullable then keep only 2 FK as PK, and remove nullable FK from PK list.


urt