I did send a message on the same topic but I don’t know where it went so I apologize if this note will end up being redundant. I am sure this is an old question but I can’t find any simple yet clear instructions on how to proceed. and here I am.
I am building a recipe app for my personal use or future use (you never know) trying to capturing old recipes of my family. I have created the 3 tables: Ingredient table, Recipe Table and the bridge table ingredient_table. So far so good and it works like a charm. However in the recipe world there are many recipes that could be used as an ingredient (i.e. pizza dough has a recipe per se, and yet it is an ingredient for a Pizza Margherita which has tomato and mozzarella as additional ingredients). The goal is to have all the ingredients including the ones from the recipe_ingredient listed all at once. I have tried different ways to handle this but to no avail. I am new to this no-code world and this dB relational structures is still a little foggy. If there is any good samaritan out there who could help I would be very grateful. Thanks
This topic was automatically closed 10 days after the last reply. New replies are no longer allowed.