Hold on - just looking at this again, and think I've figured out what I should be doing....
Should I basically drop the text fields from the main Products table for Category and SubCategory, but rather just have CategoryID and SubCategoryID.
And then have tables Categories and SubCategories.
And then in the pages that list each category, use the join query on those pages to look up Category and SubCategory in the Categories and SubCategories tables?