Combining Tables

[Guest]

I have two tables (let's call them Table 1. and Table 2.) and I would like to
combine the data into one table (let's call it Table 3.) I would like to
somehow "link" the tables so that when an update is made to either Table 1.
or Table 2, the update will be reflected in Table 3.
thanks
-Cheyenne

 

[Rick B]

That would be redundant and a waste of space. You should not duplicate data
in a properly-designed database. Also, if you changed a record in Table1,
how would Access know to update table 3?

What are the two tables? If the data is almost the same, add a field with
two options to enable you to differentiate the data. If table 1 contains
all invoices from the East office and table 2 contains all the invoices from
the West office, for example, then simply add a new field called "office"
with the options of "East" and "West".


Another option would be to build a UNION query that would combine the
records from the two tables and use that query as the record source for your
reports, queries, and forms. This method would more closely mimic what you
originally asked to do.

Hope that helps,

Rick B