Database wide constraint?

I have table 1, whose primary key may be used in table 2 table 3 .... table n, as a foreign key.

Is there any constraint that can applied, hopefully once and in one place, that ensures that for any particular row in table 1, it's value is used in only one other table (though it may be used many times in that one other table)?

Thanks, Emily Received on Wed Aug 09 2006 - 02:08:56 CDT