linking table info from 2 Access Databases

[JuniorWoodchuck24]

I have two databases created in Access 07. I'm curious if I can pull info from one database's table and put it into another table after an update and if there is a quick way to do it. For instance an auto update button would work nicely. Example below:

1st Database - Detailed individual salesman database that has multiple tables and primary IDs linked.

For instance tables are: car, models, make, color, packages. So the Car table has all the info
Model/Make/Color/Packages are columns in Car Table
Also the Car Table referrences the Model/Make/Color/Packages by their primary ID so it pulls in Primary ID / Text Description.

2nd Database - Bosses database where he will have multiple employees import their data to his database to be linked to reports. Tables and Reports in his database.

My issue - When I pull from the individual's database it only copies the primary ID over and not the text (example: Blue's ID is 1, so instead of Blue for the color I get 1). Was curious if I could link the databases to allow for an easy update from the bosses database so he can get current info regarding the individual sales.

 

[JamesMcS]

You could pull back the name of the colour rather than the number with a query. Link the tables into the boss DB and just base the report on the query... that's what I'd do anyway.

 

[kristin_110]

Cool. Helped me too!!