Take a look at this base I made for recipes/meal planners:

In the [Ingredients] table there is a Shopping List view which adds up all the ingredients necessary to make the recipes planned for the current week. It uses a series of formulas and rollups to accomplish this.

In order for my method to work, you’ll need a eRecipes] table, an eIngredients] table, and a eRecipe Ingredients] table which stores the ingredients and quantities of them required to make each recipe. I have another table called eMeals] so that I could string together multiple recipes, but you might not need it depending on your use case.

I would encourage you make a copy of that base and explore it a little to see how you can incorporate the structure with your own.

Thank you @Kamille_Parks for your reply.

At the end I used the “Recipe Organizer” template and added a checkbox field in the Recipes table.

In the Ingredients table I added a lookup field for this field.

Then I created a view in the Ingredients table grouped by the Ingredient, filtered by the checkbox - marked value.

Thank you again,

Sam