table design/relationships

[Guest]

I'm setting up an order table for a Garment, with 3 fields for Fabric
StyleIDs (outer, lining, and combo). The Fabric table has a styleID as PK.
How best to set up? In relationships it creates Orders_1 when I try to join
the 2nd
styleId.
Thanks!
Don

 

[John Vinson]

I'm setting up an order table for a Garment, with 3 fields for Fabric
StyleIDs (outer, lining, and combo). The Fabric table has a styleID as PK.
How best to set up? In relationships it creates Orders_1 when I try to join
the 2nd
styleId.
Thanks!
Don

You'll see Orders_1 and Orders_2 in the Relationships window; this is
in fact legitimate, because you have three DIFFERENT relationships
from three different fields, all to the same table.

I'm not clear, though, what tables are which here - do you have tables
for Fabrics, for Styles, and for Orders? What is each table's Primary
Key? How are the tables related?

John W. Vinson[MVP]