>Is there a way to create a foreign key constraint that allows the column to be either null or have a value in the primary key table? From the documentation that I see within SQL Server, this is not permitted.
>
According to SQL BOL it's allowed. See 'Foreign Key Constraints' topic in BOL for details.
--sb--