table design

[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.

 

[Klatuu]

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

 

[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.