Query questions

[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

 

[Joseph Meehan]

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

I am a little confused as to exactly what your database needs are. I
strongly suspect you have a tabled design problem.

I am guessing that each UPC number is related to one or more trays,
labels and caps. Further I am guessing that any individual tray label or
cap may be related to more than one UPC. Is this correct?

I am also guessing that you want to be able to select a UPC and get a
list of the tray, cap or labels related to it and likewise select a tray
label or cap and see what UPCs are related to it. Is that correct?

Are there any other needs?

I am not sure you need separate tables for trays, labels and caps.