stock sytem for garments in different sizes

[Guest]

I want to set up a database for stock codes (clotihing) where the need to be
multiple references (ie sizes) against the same stock code.

How can it be done?

 

[Guest]

Danny,

You will need one table to hold the code and other info about the garment.
Then another table linked by the GarmenID that will hold the various sized
for each garment. You will be creating a one to many relationship.

Have you also considered color?

 

[Pat Hartman\(MVP\)]

You need to differentiate between "part numbers" and SKUs (Stock keeping
units). A part number might identify a shirt. A stock keeping unit,
identifies a blue shirt, size 12.

Inventory is kept at the SKU level.