I have two tables and am trying to relate a column from each.
The first "Recipe" table has a "Planned" column with an equation to tell if it is being used that week. I used the following equation and it works perfectly: if(not empty(prop("Day")), true, false).
My second table is the ingredient list. I am trying to make another column in the "Ingredient" table that detects if the "Planned" column from the "Recipe" table is marked true. If it is true, I would like this new column in the "Ingredient" table to be marked true as well.
How would I do this? Thank you in advance!