Forum Discussion

AlexGale's avatar
AlexGale
Qrew Captain
7 years ago

Filtering over a Many to Many relationship

I have set up a basic many to many relation ship between two tables, Features, and categories. Since each feature can have many categories and each category can have many features, I have set up a join table in between them, "Assigned Categories". 

However, my users typically interact with the app through the "Features" table, not the "Assigned Categories" table. Is there a way allow users to filter my "Features" table by category, without having to go into the join table?

Thanks
  • Update: I realized that a multi-select text field instead of a category table worked way better and did everything I wanted it to.