As an example, let's say I have a category column named genre of music in enum. (hip-hop, rock, r&b, etc...)
when I pick a certain one, I would like my sub-category column named artist (in enum as well) to show me only the artist in that genre.
What is the best way to go about this?
User | Count |
---|---|
16 | |
13 | |
8 | |
7 | |
4 |