Good morning. I am new to access. I am attempting to build a database to help with my business and have run into the first of probably several problems and hopefully someone here can help. My questions are as follows. I have built tables for my part numbers and want to assign categories and sub categories to each part. Should each category have its own table or should I group them into one table? Likewise should each sub category have its own table? (All sub categories are unique to each specific categories). I will be using the categories and sub categories for looking up part numbers and reporting.
After I conquer that, when part numbers are being entered for the first time, I want to have a lookup menu for the category. After the category is assigned, I want a lookup for only the sub categories that are applicable to the specific categories.
I appreciate any and all help.
Thanks in advance
Boltman