Combining Two Tables into One

[kvn5x4]

Hello all, it has been a while since I last posted.



I have a new issue that I have been trying to work on. I am trying to create a "Master" table between two tables. The two tables have identical fields names, etc, but range in value for each field. I have illustrated what my purpose is below. The issue I am coming across is how to actively update the tables if I make a change in one. I.E. If I make a change in the "Master" table, how to have same change made in the table is it pulling data from. For further information (if it helps), the text or number listed in field 1 will never duplicate. It will always have a unique number.



I've been reading up on "union", append queries, etc., but I am not really sure which would best fit my needs nor the capability of accomplishing this task. Any help is appreciated!

- Kyle

[June7]

Why do you need to retain the two original tables?

Are other tables related to the two original tables?

[kvn5x4]

Let me give you a little background first. We have three databases for our company, one for each product line. Each product line enters test result info into a form and is saved into a table. However, our record keeping personnel sometimes need to update or change some information on the test results.

I am creating a "master" database linking all three databases into one. This will allow our record keeping personnel to view all information without having to continually open multiple files for different products that are made from the product lines. This answers your first question

To your second question, no. They are stand-alone tables.

Thanks!

[June7]

Why separate database for each product line? Are the files so large?

Set links to the individual tables and use UNION query to provide a 'Master' dataset. Cannot do edits in the UNION. Edits must be done in the tables. Edits will be reflected in the UNION.

[kvn5x4]

Would there be a way to make edits in the 'Master' dataset and have those changes reflected in the individual tables?

[June7]

See comments in previous post.