Database Design - Please HELP!!!
I am woking on an inventory database. I want to have 4 categories on the database. If I make different layouts for the different categories, then it would still mean that each time I create a new record for 1 category, the other categories contain that record as well. I don't want that to happen.
So, maybe having different layouts for different categories is not the option. Can someone please help me with ideas?