[resolved] How to design the tables???

[SaharaWizard]

Hello Guys
I am working on a little inventory application (VB6, ADO, Access2000).
I am trying to design several tables to organize and manipulate data regarding production and raw material (pretty standard stuff for an experienced developer).

I keep track of raw material in a table called tblRaw
I keep production records in tblOrder.

For each production item (single record in tblOrder) user have to look at list of raw materials and pick up 3 to 5 different raw material and uantities to be used.
I have to do the issues:
[B]
1. Keep track of how much of each raw mat. will be left in stock
2. At the time of creating order I have to ALLOCATE the specific quantities, but at the date of production the ALLOCATED quantity should be subtracted from the available amount.
3. if production get cancelled the amount should be added back to the original amount of each raw material.

I have thought of a few different ways of going about it, but I am hoping somebody with more experience be able to tell me what is the most practical way To design the tables.

Thank you in advance.