Inventory table into smaller tables or just one

[drtaclem via AccessMonster.com]

I'm building a database for a construction database. The inventory items
will have a category (10+ types) and also a sub category (10+ types). Would
this be better to keep as one table, or break into smaller tables for each
category. If the user creates a new category I would then create a new table.
It seems to be easier to keep in one table. Am I correct in this assumption?

thanks

 

[John W. Vinson]

It seems to be easier to keep in one table. Am I correct in this assumption?

Absolutely. Your Categories table would have fields for Category and
Subcategory; you could use a "SELECT DISTINCT" query to create a combo box
(for example) displaying just one record for each category, and another query
referencing that combo box to create a dependent combo box showing only the
subcategories for the selected category.