Please Help!

[Santi]

So far I been trying merge information from two link tables into a master
file that will update everytime there’s a revision, addition, or deletion of
a record but I been unsuccessful. I know that this can be done but I can’t
seem to find the way of doing this and several people have given me some
suggestions but so far nothing has helped. To be a little bit more detailed
of what I’m trying to achieve below is an example of what my end result needs
to be. Any help is greatly appreciated.

Ex:

Table 1

(field one) (field two) (field three)
Vendor Number Supplier Product Desc

Sams Sony 42’ Plasma
Sams Sony HD DVD
Sams Sony Portable DVD


Table 2

(field one) (field two) (field three)
Vendor Number Supplier Product Desc

Sams Phillips Digital Camera
Sams Phillips Refrigerator
Sams Phillips AC


End result (Query)

(field one) (field two) (field three)
Vendor Number Supplier Product Desc

Sams Sony 42’ Plasma
Sams Sony HD DVD
Sams Sony Portable DVD
Sams Phillips Digital Camera
Sams Phillips Refrigerator
Sams Phillips AC

 

[Fred]

Dear Santi,

You did a nice job of showing the database action you are trying to do
(which I think that an append query or two would accomplish. ) But your
description seems to point to a fundamental misunderstanding of using and
linking tables and thus a faulty foundation for your endeavour.

May I suggest that you (without using database terminology) roughly describe
overall what data you are trying to store and what you are trying to get out
of it?

Fred

 

[KARL DEWEY]

Use a union query --
SELECT [Vendor Number], [Supplier], [Product Desc]
FROM [Table 1]
UNION ALL SELECT [Vendor Number], [Supplier], [Product Desc]
FROM [Table 2];

No need to put it into a table as the query will have updated information
every time it is run.