Re: Database Design Question - any suggestion?

You can make a table with the following atributes:

Key - for example some autonumber
ArticleNo
Colour
Size
Number - this is the number of articles with corresponding colour and size
Date/Time - if you need this

Example:

(0001, t-shirt-man, yellow, small, 128, 10dec2004/10pm)
(0002, t-shirt-man, yellow, elarge, 0, 10jan2004/08pm)
...
(0017, jeans-wom, blue, large, 29, 08dec2004)
.....

Now you can set queries. For example give me all Colours (or/and size...) for ArticleNo = T-Shirt.
You can set an inverse query: give me all T-Shirts for Colour = Yellow.
( as pair (ArticleNo, Colour) is like m-n).
You can create sreen with a dropdown box for example for ArticleNo( also for other atributes) and corresponding parameters query, etc. You also need one date entry screen.
I hope this will help.

Vladimir Odrljin Received on Mon Dec 06 2004 - 19:01:56 CST