• 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

    http://www.insidesql.de

    http://www.familienzirkus.de

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]