Link tables

[Guest]

I have two tables, one with product name, lot number, quantity, disposition
and another table with product ID number and product name. I need to link the
two tables into one table

 

[Guest]

Use a make table query based on both tables....

 

[Jeff Boyce]

A Make Table query will generate a new table. This is rarely necessary,
since a simple select query with the two tables joined can return any/all of
the fields from the respective tables.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

See below.....

A Make Table query will generate a new table.

Doesn't it sound like that is what he's asking about? Do you know an easier
way to put data from both fields into one table?

This is rarely necessary, since a simple select query with the two tables joined can return any/all of the fields from the respective tables.

This is most likely what I would do to utilize the data off of both tables
so as to keep my data normalized.

 

[Jeff Boyce]

Jason

I responded with notions from my experience. I don't know that there's an
absolute right/wrong answer. I have found, though, that creating tables
(i.e., Make table queries) just to have a collection of data is rarely
necessary or desirable.

As you point out, a simple query can gather the data and make it available
to most other processes.

As for what was originally asked for, I try to offer alternatives if asked
how to do something I'm not sure is a good idea. For example, it is
possible to drive nails with a chain saw ... but not too smart!

Regards

Jeff Boyce
Microsoft Office/Access MVP