setting up a stock database for clothing with multiple size codes

[Guest]

I am trying to set up a stock cotrol data base for a retail clothing
business. My problem is that a single stock code can have variations on size,
colour, cost and selling price. I need to monitor the stock by group and down
to individual item, but I am keen to avoid creating a stock record for each
individual item down to size colour and price as this will create thousands
of variations.

Any ideas on keeping it as simple as possible would be appreciated

 

[John W. Vinson]

I am trying to set up a stock cotrol data base for a retail clothing
business. My problem is that a single stock code can have variations on size,
colour, cost and selling price. I need to monitor the stock by group and down
to individual item, but I am keen to avoid creating a stock record for each
individual item down to size colour and price as this will create thousands
of variations.

Any ideas on keeping it as simple as possible would be appreciated

If you want to keep track of the inventory of each size, colour, and cost,
then you need a record of each size, colour, and cost. No option there!!!

I suggest though that you could use Access' relational capabilities to help.
If you have a table of Products ("Men's oxford shirts") you could have a one
to many relationship to a table of SpecificProducts, with fields for
ProductCode, Size, Colour, Cost and Price. The Primary Key of this latter
table could consist of the three or four fields which jointly identify a
specific price.

John W. Vinson [MVP]