Friday, March 30, 2012

Link Two tables

Hi All,
I want link two tables from two different database located on different server. they both are not have unique reference.
Table1 from db1 is one field(Emp_id) is auto increment number And another one is table2 from db2(Newly created table). I need some fields from table1.db1 to table2 db2. When all are user modified table1.db1 then automatically update table2.db2

thanksI think you recieved answer to your question.

http://www.msdner.com/forum/thread586326.html

Not sure what else you are looking for.

No comments:

Post a Comment