help with user-friendly form

[mgrill]

I'm trying to create a "user-friendly" data entry form for inventory/despatch purpose in MSAccess2003.
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:

size  Shop1  Shop2
 35     1
 36     1      2
 37     3      1
 38            1
 41     2      1
 43     3      2
etc.

and save those records with the given colorID.
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!

[Stewart Ross]

Hi there mgrill. Aside from references to the 'boss' in your post, this looks like some form of assignment question to me - and if it is, we really cannot do your assignment for you.

We are happy to help you with specific questions where you have tried something and got a bit stuck - but to ask us how to design a user-friendly form from scratch is like asking us how to design the best database in the world ever, or any other broad and unanswerable question.

If you could be more specific we will do our best to help you, but not, I'm sorry to say, with your question as you have posted it. Please read the posting guidelines at the head of the forum, and (if this really is an assignment question) our FAQs on posting homework questions.

Thank you

MODERATOR

[mgrill]

Hi there mgrill. Aside from references to the 'boss' in your post, this looks like some form of assignment question to me - and if it is, we really cannot do your assignment for you.

We are happy to help you with specific questions where you have tried something and got a bit stuck - but to ask us how to design a user-friendly form from scratch is like asking us how to design the best database in the world ever, or any other broad and unanswerable question.

If you could be more specific we will do our best to help you, but not, I'm sorry to say, with your question as you have posted it. Please read the posting guidelines at the head of the forum, and (if this really is an assignment question) our FAQs on posting homework questions.

Thank you

MODERATOR

Thank you Stewart, I understood your point. Sorry,I (probably by mistake) tried to describe the global picture instead of asking for specific help. The thing is, that I tried to use an AfterInsert event with an SQL to insert a 14 rows bay 3 colums matrix for entering the size-sortiment data and requery the subform to exlude the not filled (zero) records in that matrix, where I reached the dead-end.
Thus, I came the conclusion, that my approach easily might be wrong and turned to your forum the get some light on the global problem of mine.
Anyway, many thanks to you guys, it's great opportunity to have such a powerfull resource by hand when you are in trouble at the early stages of the Access Academy, and I do promise to be more specific next time.

Best regards,
mgrill