How to Optimally Organize a Hierarchical Category Structure?

[artoritorian]

Hey everyone! I could use some help figuring something out. I've got a company database and I need to assign categories to each company. The structure is four levels deep: Industry Type → Group → Category → Subcategory.

Here's the tricky part: a single company can belong to multiple industry types, groups, categories, and subcategories at the same time. But there's also a hierarchy in place—not all combinations are valid. For example, certain groups only belong to specific industry types, certain categories only belong to certain groups, and so on.

I'm not sure how to implement this optimally. Any advice would be really appreciated!

[emillod]

I don't know if that's the case, but probably you should create (the easiest way) 4 multi-enum fields with dynamic options. Thanks to this you'll be able to choose multiple options on each field and you'll only see available options based on previous field. Additionally you can set invalidation rules.