Filtering over a Many to Many relationship

Question

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

AlexGale · Answer

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

Sign up

Login to the community