>Curiosity... is it considered bad form to create a Foreign Key and turn off all the checks and enforcement options?
>
>I have a few cases where a relationship exists but the related item may not be known till latter on.
In case like that you should allow NULLs for the FK column and put NULL in the records where FK is not know yet.
--sb--