Re: Database Design Question - any suggestion?

You can make a table with the following attributes:

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, 08jan2004/08pm)
...
0017, jeans-wom, blue, small, 328, 02oct2004/11am) ....

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 screen with a dropdown box for example for ArticleNo(also for others attributes) and corresponding parameter query, etc.
You also need one date entry screen.
I hope this will help.

Vladimir Odrljin Received on Mon Dec 06 2004 - 18:54:38 CST