Categorizing table contents

[Alaa Wasfy]

I'm working on building a database using access 2010.


frankly I have a basic experience with access but I'm not doing so bad.
I've built my DB tables but I'm facing a problem which is, I have "purchase categories" table which contains two fields "CatID" and "Category"

"CatID" "Category"
Ra-Ma Raw Materials
Co-It Consumable Items
Tools Tools

and I have another table for all the subcategories, for example..
I have hundreds of Raw Materials, consumable Items with various types.
and I've listed all those types in one table.

"ItemID" "Item"
RM-001 Metal Sheets
CO-001 Wilding Supplies
TL-001 Wrench

now I want to create my entry form that way, I want to create a combo box gives me the ability to chose the the category that I want for Ex. Raw Materials, and another combo box only shows the items listed for raw materials such as RM-001, same for other categories.. and I want to store these values in the suppliers table.

looking forward for a positive reply and sorry for the poor English.
Thank you very much.

[June7]

The Items table needs a field for the CategoryID. Then you want to build dependent (cascading) comboboxes. Check out this tutorial http://datapigtechnologies.com/flash...combobox2.html