The items are classified by
Brand (1)-----(M)Models(1)------(M)Colors(1)------(M)Sizes(1)-----(M)Shops-----Pieces fields.
What is required: set up a (sub)form, where for a given Model's (first) color is being entered, what triggers a subform to enter the different size-sortiment for that color indicating the number of despatched pieces for the different shops like in the following matrix:
Expand|Select|Wrap|Line Numbers
- size Shop1 Shop2
- 35 1
- 36 1 2
- 37 3 1
- 38 1
- 41 2 1
- 43 3 2
- etc.
And just to add some hot pepper into the open wound, the boss asks for the possibility to bring up those tables for the previous colors (if there exists) to help in deciding the near-equal distribution (at least by sizes).
Any help is greatly appriciated in advance!