Now, not to take advantage of you, how would I start going about deleting a category/sub category and removing the value from any products that used them?
No worries! :)
Delete the categories is easy it self. But if you wanna delete a main category you need to delete the Sub category to, and check the products that has that Sub Category value.
1. Do the delete/edit with the help of WA Database -> DataAssist Pages and use the table for Sub categorie recordset. Same thing for the main category tables recordset.
2. Create your own page with Main and Sub Categories and then make a delete/edit function.
I can make a sample of the 2 ways above later tonight, i have your table data structure for the categories.