Hello,
I'm new to this forum and just started working on building a manufacturing database for my family's small business (cheese making).
I would like to allow any database user to easily use a form to build an expression that calculates recipe ingredient amounts. (I want to make a user-friendly form for building these expressions because users will need to be able to build different recipes based on the cheese they are making, I can't just build the ingredient formulas one-time and walk away)
For example (form screenshots included)
- on frmProduct, the user inputs the different ingredient steps in a specific order (building a recipe), like pumping milk and estimated cheese wheels produced, to make a specific cheese product (i.e. Alpine)
- The user needs to input a formula for estimated number of cheese wheels based on the milk pounds used (i.e., ((Milk Pounds)/8.6)/11).
- This formula could be different depending on the product recipe, so user needs to be able to input it into the product recipe form
- Then on frmProduction, the user begins filling out the Production sheet (which is generated from recipe built on frmProduct, think of it as an instance of the recipe) to make the cheese
- The user first inputs the number of milk pounds used (first step of the recipe)
- The last step of the recipe "estimated cheese wheels" then needs to take the user entered formula for estimated number of cheese wheels from the recipe sheet that was built on the frmProduct, and calculated the number of cheese wheels on frmProduction
Any ideas on building this process?