sharing information

W

Wendy

I want to know how I can share information from one database with another. I
am making a contact list where many of the contacts are with the same company
and I don't want to have to continually add the company address in. Is there
a way that I can set up Access to insert the company address when the company
name is listed?
 
K

KARL DEWEY

Use one of your Access databases to store the list of contacts. In all of
the others click on menu FILE - Get External Data - Link. Find the storage
database and select the contact table, link.
Whenever you add to the storage table all of the databases that are link can
see the newly added data also.
 
J

John Vinson

I want to know how I can share information from one database with another. I
am making a contact list where many of the contacts are with the same company
and I don't want to have to continually add the company address in. Is there
a way that I can set up Access to insert the company address when the company
name is listed?
Click to expand...

Do you mean multiple *databases* - mdb files, each containing multiple
tables, forms, reports, etc.? Or multiple *tables*?

If it's tables, what you're asking is just what relational databases
are designed to accomplish. You don't need to - and shouldn't! - copy
the company address or company name from one table to another; you
should have a foreign key, CompanyID or the like, to link the tables,
and create Queries to bring the data from the two tables together.


John W. Vinson[MVP]
 
Top