Query questions

J

Jessica

Hello All,

I have two questions. I have a master table each record has its own
product UPC number which is the primary key. I have several other tables
for example trays, labels, and caps. In the master table I have to
select which tray, label, and cap item numbers go with each UPC number.
My first question is when I create a query I know I must add the UPC
feild from the master table but do I select the other fields from the
master table or the idividual tables since the primary key from the
idividual tables are fields in the master table? And my second question
is I have some UPC that have more than one label which I think I just
answered my first question when creating a query I would have to select
the fields from the master table


TIA,
Jess
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Append Crosstab Query to Existing Table 0
How do I use a table to validate data being entered into another 1
Creating relationships 0
Syntax error(missing operator) 0
List all tables, including document structure 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Add a sequence number(question number) to a paragraph which has a question and 4 options and answer 0
copy paste but not keying in works 1

Top