You can't create foreign keys accross tables that are not in the same database.

All I was saying is that you could create two Schema's within the same database and then...

You can't create foreign keys accross tables that are not in the same database.

All I was saying is that you could create two Schema's within the same database and then...

It's deffinately possible to create relationships between tables in different schemas so long as both tables exist in the same database

This adds a foreign key constraint on the Sales.Order table...

Are you saying you somehow duplicate the common data into each apps database or that you have a system in place where each app accesses the common data from a...