Compiling Information From Subordinate Databases

[Guest]

I have five subordinate databases I need to dump data from into a master
sixth database at the upper echelon. All the tables are exact duplicates of
each other, only the data differs. I need to be able to see all the data
from each of the five subordinate files on one table. I have linked all the
tables I need from each database and set up master tables to collect all the
data for my forms and reports. I have joined the linked tables to my master
tables. When I open the linked tables I can see the data from the
subordinate file and it updates correctly. I think I need to use a many to
one relationship (many Soldiers from the subordinate side to one master
table) but Access will only create a one to one relationship. The primary
keys are the same on all tables (tables are cloned).

 

[Douglas J. Steele]

I'm not quite sure what you're trying to do.

If you've got both linked and non-linked tables in your master database, you
cannot create relationships between them. It's not possible to create
relationships between tables unless both tables are in the same database.

 

[Guest]

I have tables in the subordinate databases that I used the "Link Table"
selection from the pop up menu I got by right clicking in the empty area of
the database window to create linked tables in the master database. I then
went in to the relationship view and created relationships from the linked
tables to my master table. I can see all the data from my subordinate
databeses on the linked tables but my master tables are still blank and all
my forms, reports, and querries dependent on the master tables are blank as
well.

 

[Douglas J. Steele]

I think you may be misinterpretting what relationships do.

Establishing a relationship doesn't create data. The fact that you've
created a relationship will not populate your master tables.

As well, as I mentioned previously, while relationships can be created to
linked tables, they don't do anything.

 

[Guest]

So what your saying is that there is no way access can copy data from one
database to another?

 

[Guest]

So what your saying is that there is no way access can take data from one
database and use it to populate another?

 

[Douglas J. Steele]

Not at all.

However, it's not an automatic thing. You can link tables from one database
to another. You can write queries to populate a table, given the values in
one or more other tables (either in the same database or in other
databases). None of those things, though, involve creating relationships.