My table is a list of articles, with each article belonging to a category and then a sub-category. These last 2 are drop-down fields, but at the moment they are not related - meaning, the sub-category field of an article in category 1 will show all sub-categories of ALL categories instead of just the sub-categories of category 1.
How would I go about relating the categories and sub-categories?
Optimally what I’d prefer to do is actually have another table listing all categories with their subcategories and then link that table to my article list table. But I’m running into the same problem there too - subcategories aren’t related to categories again.
Any help would be much appreciated! Thank you.