Need help to model a system
I have a problem, which I can't seem to find a GOOD solution to. In the system I am creating I have an Article(ArtID, Artname) table. Register, alter and delete articles are the easy parts. Now, her comes the tricky part:
For every article it must be possible to "place an order" (really just a number, saying how many of that article you want delivered that week) for every week, four weeks from today.
Example of the webbased form, when it is week 2:
ArtID (112233), Artname (Article1), Week3( ), Week4( ), Week5( ), Week6( )
When I fill out the orders in the empty ( ), and clicks the submit button, the orders goes into the system. And I must be able to do a query to get the orders like this:
ArtID (112233), Artname (Article1), Week3(5), Week4(0), Week5(9), Week6(3)
Getting the ArtID and Artname from Article, of course is easy. But how can I, as smooth as possible, model the DB so that the updating of the weekorders is easy?
Thank you very much!!