Hello,
I am trying to build a recipe and ingredient database that also can create reports allowing the recipes to be used. However, I cannot make the transition from excel yet as I am running into problems. The appeal of access was that I can use the same form and template for everything and I could consolidate 4 spreadsheets into 1 database but I'm stuck now on what I thought would be the easiest part.
Recipes are broken down into 3 or more steps with different ingredients in each step such like the following
Code:
Step Ingredient Description
1 100 Flour
1 300 Sugar
2 129 Eggs
3 600 Chocolate Chips
3 650 Milk Chocolate chips
Ideally I want to combine the cells that say step 1 and replace with instructions that correspond to those steps. Or find a way to group the steps together so its clear these 5 ingredients are all in step 1. Below the 1's were replaced with Mix 30s High, 2 with mix 10s Low, and 3 with Mix 20s High Mix 10s Low.
Code:
Step Ingredient Description
Mix 30s High 100 Flour
300 Sugar
Mix 10s Low 129 Eggs
Mix 20s High 600 Chocolate Chips
Mix 10s Low 650 Milk Chocolate chips
The problem is that I do not know how to make it dynamic. Some recipes have 10 different ingredients in stage 1 while others have only 4. Currently I have 30 different ingredient spots available per recipe, with their item code, description, weight, and stage stored with them. Is there a way to dynamically replace the stage number by consolidating them together then adding the mixing instructions for that stage in their place? This way I can use only 1 report for the recipe when it comes time to retrieve it. Is what I am trying to do feasible? Or will I have to have several different reports for different sized recipes?