Compiling Information From Subordinate Databases

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).

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.



--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"SGT Beene" wrote in message
...
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).

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" wrote:

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.



--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"SGT Beene" wrote in message
...
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).

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.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"SGT Beene" wrote in message
...
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" wrote:

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.



--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"SGT Beene" wrote in message
...
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).

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

"SGT Beene" wrote:

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).

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" wrote:

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.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"SGT Beene" wrote in message
...
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" wrote:

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.



--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"SGT Beene" wrote in message
...
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).

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.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"SGT Beene" wrote in message
...
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" wrote:

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.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"SGT Beene" wrote in message
...
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" wrote:

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.



--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"SGT Beene" wrote in message
...
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).