Refering data in two seperate schemas/databases

[MarleneD]

If I have data in database 1 and similar data in database 2

- when the results are produced on a webpage from database 1 - how could I also create a link to relevant data in database 2?

i.e. from database 1 - the link for'Seattle' appears - if I click on Seattle - it will display the record from database 2.

Is there a data linking mechanism that can take care of this?

 

[SonOfEmidec1100]

Do it the same way you would if the table was in the same database but prefix the table with the second database name and dbo placeholder.

ie DB2..TableName

Maybe this will help you