Hello helpful community!
So I have a table. Let’s say it’s a table full of recipes.
Each recipe row has a multi-select field called ingredients.
So maybe there’s a recipe called Scrambled Eggs and in the multi-select field called ingredients there are three entries:
…I’d like to create a new table called ingredients where each row in the table is an ingredient and for each ingredient I want to be able to see every recipe that uses that ingredient.
So, for example, for the row called milk I’d see at least three recipes:
How do I do this?
I suspect my original setup is flawed and I should have started with one table called Recipes and another table called Ingredients and then figured out how to pull in all the ingredients I want for each recipe. But is there another way with the multi-select setup I already have?