Rob,
Users creating bad data and being lazy.... So many stories.
To prevent this, change the permissions on those two tables to prevent certain User Roles from being able to Add Records.
Go to settings for the table in question
The right hand column is Workflow & Permissions
The second one down is Access
This will show you all the roles and the permissions the have in that table
Uncheck the 4th column from the right, Add
Do this for both tables Category 1 and Category 2
Now they can use the data in those tables but not add to it. I suggest you also take away their ability to Modify.
Don't take away View as suddenly they will be unable categorize the Inventory items.
------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------