When adding a new inventory item into the database, the category that it is "filed" under should be a drop-down list of current/existing categories. Otherwise, too many and duplicate categories will be created over time. Then, if the category that the person wants doesn't exist, there should be an ability to add a new category.
When adding a new inventory item into the database, the category that it is "filed" under should be a drop-down list of current/existing categories. Otherwise, too many and duplicate categories will be created over time. Then, if the category that the person wants doesn't exist, there should be an ability to add a new category.