Hi

You could do this using a instead of trigger or using a check constraint and
function. The latter may not perform that well.

John

"Paul" <paul_coombes_home@hotmail.com> wrote in message
news:19ca7866.0310280619.211d9fd2@posting.google.c om...
> Hi,
> Does anyone have any suggestions on the best to go about enforcing a
> relationship between two tables that exist within separate databases
> on the same SQL Server instance.