Thread: linking
View Single Post
 
Old March 28th, 2006, 08:21 AM
mmcdonal mmcdonal is offline
Friend of Wrox
Points: 9,611, Level: 42
Points: 9,611, Level: 42 Points: 9,611, Level: 42 Points: 9,611, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

You can link the two databases and share identical data between the databases so you only have to store it once in all your databases, and it is accurate and the same in all your databases.

Create your shared data in one of your databases. Then from the other databases where you want to see this data, select Insert > Table > Link Table, and then link the table with the shared data into your database.

You will probably want this shared data to be the only data in the table that you are sharing so that unrelated data is not shown in other databases. If this is not feasible at this time, then you can create a view or query of the table, and then link to the query to see the data.

HTH

mmcdonal