table design

W

Walmondo

I have customers, sales, inventory & brands tables. What is the best way to
go about hooking a sizes table to this? The sales table is a junction table
with one product from inventory being sold many times.
 
K

Klatuu

Items in Inventory have sized, right?
But, then do different items have different kinds of sizes or different
ranges of sizes?
 
S

Steve

TblProduct
ProductID
ProductDesc
<Other relevant product fields>

TblProductSize
ProductSizeID
ProductID
ProductSize

If all your sizes are standard, you might have ....

TblProdSize
ProdsizeID
ProdSize

and then have ProdsizeID in TblProductSize instead of ProductSize.

Steve
 
W

Walmondo

This is for a shoe store. Each product in inventory will have many shoes with
different sizes but the same productcode which is the primary key of my
inventory table connecting to the foreign key productcode of my sales table.
My inventory table also has an autonumber field doing nothing.
 
Top