Forum Discussion
KateTheriault
6 years agoQrew Cadet
Sure. Here is an example recipe (although this only nests 3 levels deep).
Top recipe Bolognese consists of:
1 unit of Subrecipe: Sauce
Ingredient: Tomatoes 8 oz
2 units of Subrecipe: Bolognese spice blend
Ingredient: Garlic Powder 0.01 oz
Ingredient: Thyme 0.01 oz
Ingredient: Pasta 8 oz
Ingredient: Salt 0.02 oz
I currently have this functionality in my application. I have two tables "Recipes" and "Subrecipes". I have two one to many relationships from Recipes to Subrecipes. In one of those relationships, I track Master Recipes and the other is used to track Sub Recipes. Every recipe can also have ingredients at any level (linked in a many to many relationship from Recipes to Ingredients).
What I would like is to get a report of my top recipe Bolognese with all of the subrecipes and ingredients listed out. Unfortunately subrecipes and ingredients are not the same entity, but it would be fine if they are reported in two different tables in the report. It would be even better if we could somehow merge them together (if I had everything I've ever dreamed of, haha).
Thank you,
Kate
Top recipe Bolognese consists of:
1 unit of Subrecipe: Sauce
Ingredient: Tomatoes 8 oz
2 units of Subrecipe: Bolognese spice blend
Ingredient: Garlic Powder 0.01 oz
Ingredient: Thyme 0.01 oz
Ingredient: Pasta 8 oz
Ingredient: Salt 0.02 oz
I currently have this functionality in my application. I have two tables "Recipes" and "Subrecipes". I have two one to many relationships from Recipes to Subrecipes. In one of those relationships, I track Master Recipes and the other is used to track Sub Recipes. Every recipe can also have ingredients at any level (linked in a many to many relationship from Recipes to Ingredients).
What I would like is to get a report of my top recipe Bolognese with all of the subrecipes and ingredients listed out. Unfortunately subrecipes and ingredients are not the same entity, but it would be fine if they are reported in two different tables in the report. It would be even better if we could somehow merge them together (if I had everything I've ever dreamed of, haha).
Thank you,
Kate