Combine Tables with Similar Fields

[Alchemist61]

Hi Guys,
Can you advice me how to combine a total of Six Tables with Similar fields
into one master table and still maintain the six tables?
Thanks.
R.J

 

[Stefan Hoffmann]

hi,

Can you advice me how to combine a total of Six Tables with Similar fields
into one master table and still maintain the six tables?

You know commandment #1?

http://www.mvps.org/access/tencommandments.htm

Use a UNION query if you still like to ignore it...


mfG
--> stefan <--

 

[John W. Vinson]

Hi Guys,
Can you advice me how to combine a total of Six Tables with Similar fields
into one master table and still maintain the six tables?
Thanks.
R.J

You can combine them by using six Append queries (or a single append query
based on a UNION query).

As for maintaining the same data redundantly in two different places... why on
Earth would you want to do so!? It's extremely bad design and unnecessary.
Just combine the data into one table (perhaps with an additional field to
indicate which table the data came from), and use Queries to generate your six
subsets; then delete the six tables.