relationship/report question

J

Jessica

Hello

I am confused as how relationships work and wanted to see if I have it
right with the database I am working on now. I have a products table and
a labels table. One record in the products table can have a front label
and a back label which are two separate records in the labels table. Two
records in the labels table can belong to more than two records in the
products table (this is because I have a record in the labels table with
a value No back label which may apply to many records in the products
table. So with my tables setup that way I made a junction table to link
the two. Is this the right path? If so for my report I need to list the
front and back label in separate fields according to my primary key in
the products table. I can get one label to show I think the first one of
the two in the labels table but can't get the second.

I hope I didn't make it sound too confusing.

TIA,
Jess
 
J

Jessica

Hi David

As I have it setup now
Table Products - fields UPC, etc...
Table Labels - fields item number, label description
Junction Table - fields UPC, item number

Usually the first item number of each label is the front. When I build a
query it lists both label item numbers. I just don't know how to get the
second item number to show in my report.

I hope that clears it up better,
Jess
 
J

JACY FONSECA

Jessica said:
Hello

I am confused as how relationships work and wanted to see if I have it
right with the database I am working on now. I have a products table and
a labels table. One record in the products table can have a front label
and a back label which are two separate records in the labels table. Two
records in the labels table can belong to more than two records in the
products table (this is because I have a record in the labels table with
a value No back label which may apply to many records in the products
table. So with my tables setup that way I made a junction table to link
the two. Is this the right path? If so for my report I need to list the
front and back label in separate fields according to my primary key in
the products table. I can get one label to show I think the first one of
the two in the labels table but can't get the second.

I hope I didn't make it sound too confusing.

TIA,
Jess
Click to expand...
 
Top