This is a question about maintaining the data integrity within the database system I'm using.
Currently I have a User table, that doesn't change much, but several different programs use it.
Essentially what I'd like to do is have tables in one database use a foreign key on a column that is in a separate database.
Database 1: "CommonDb"
Contains Table: UserInfo
Columns: Login_Name(PK), Full_Name, User_Title
Database 2: "Sales_Store"
Contains Table "Sales"
Columns: Sale_Id(PK), TimeStamp, AddedByUser, Amount
Database 3: "Account"
Contains Table "Accounts"
Columns: Account_Id(PK), TimeStamp, Account_Manager, Current_Balance
And the Idea would be that the "AddedByUser" field and the "Account_Manager" field would use the user LoginName from the CommonDb.
Perhaps there is already a good way of doing this, I'm not to sure, but any thoughts and suggestions would be welcome.