Mapping one table to another in diffirent databases

I want to map a table1 in one database to a table2 in another database. That way I can populate the table2 with the information that table1 has. How would you go about doing this. Very new at this and need help! Thanks alot .Do you mean that if an INSERT, UPDATE or DELETE Occurs you wan the action reflected in that table?|||Originally posted by Brett Kaiser
Do you mean that if an INSERT, UPDATE or DELETE Occurs you wan the action reflected in that table?

yeah, whenever something getts updated in one table in the database, the results will also reflect on the other table that lies it the other database. I am under the impression that yu have to map the databases together for that to happen. Is this something that is done with DTS? hopefully that makes a little more sence.|||Sounds like a job for triggers.|||Transactional replication can also be an answer.

manually update a table

i have 2 tables in an sql db. table1 has 2400 records and table2 has 1400 records. if i open the table and select all rows in table2 and try to manually edit the contents of a field i receive the following error:

communication link failure.

if i open the table and select top 1000 i can manually edit any value with out any problem.

if i open table1 and select all the rows i can edit any value i want with out any issues.

can it be that the size of the table prevents me from editing when i select all the rows?

extra info:
table1 has more records and more fields but the fields in table2 are larger (navchar 50 compared to navchar20)

Thank You,
ThomasDo you have a primary or unique key on your tables?|||Try to use the OLE DB provider for SQL Server instead an ODBC driver, and see whether you problem persists.|||Are you doing this in EM? If so, it is highly reccomended you do not edit data this way as it creates a big overhead with locks. Writing appropriate update statements would be better. (again, if you are doing it from EM)

HTH