Combine databases

[Guest]

Issue 1: I have several databases from different Engineering Departments
that I would like to combine. These departments have been reorganized and
the bulk of the work will be done by one engineering department. The problem
I'm having is that all the databases have hyperlinks to the actual form
filled out by our employees when they requested the change. I can import the
tables from the databases into the primary database but I'm loosing the
hyperlink, it shows the link but it is no longer a hot link

Issue 2: If I created a UNION query to combine the data from all the
imported tables could I then run a search form (query by form) based on the
UNION query? I don't want union all because I don't want the duplicates.

The reason for this is that we have several different products and with the
departmental changes 1 group of engineers made up of engineers and designers
from what was previously product specific engineering departments have been
reorganized into this department and they may not be familar with changes
made previously so they need to have the ability to search all the tables and
find out if change X was considered before.

 

[Joseph Meehan]

Issue 1: I have several databases from different Engineering
Departments that I would like to combine. These departments have
been reorganized and the bulk of the work will be done by one
engineering department. The problem I'm having is that all the
databases have hyperlinks to the actual form filled out by our
employees when they requested the change. I can import the tables
from the databases into the primary database but I'm loosing the
hyperlink, it shows the link but it is no longer a hot link

Sorry, I seem to remember some questions on this one, but I don't have
an answer for you.

Issue 2: If I created a UNION query to combine the data from all the
imported tables could I then run a search form (query by form) based
on the UNION query? I don't want union all because I don't want the
duplicates.

I would combine all the tables if they are holding the same information.
Depending on your needs you may want to add a field to identify the sources
of the information.

 

[Guest]

There were some very similar questions to this but not exactly what I was
looking for. By combining the tables did you mean into 1 table?

 

[Joseph Meehan]

There were some very similar questions to this but not exactly what I
was looking for. By combining the tables did you mean into 1 table?

You have three tables. If they have the same fields (even if they now
have different names and not all three tables have all the fields) you
should consider using append queries to put all the data into a single
table. That is if table 1 has three fields color size date and 200 records
and table 2 has 100 records with finish (being a color) size and date and
the third table has color and size with 150 records you would combine them
into a table with color size and date and have 450 records.