quote:
but if one wants just the ID to be a foreign key then one must abandon DRI and instead write triggers or other code to enforce the relationship.
would you really want to let trigger handle RI?
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]