|
||||||
Chef's Kitchen Helper By Richard Rost ![]() ![]() ![]() Determine Possible Meals Based on Available Ingredients. This video will show you how to use a query to determine what dishes you can make based on the available ingredients. Not limited to just the kitchen. You can use this to calculate needed components for any product that involves multiple parts. Whether you're selling food, computers, or machine shop parts, these techniques work for everyone. Camila from Milan, Italy (a Platinum Member) asks: I run a small kitchen. I would like to have a database that includes a list of all of the recipes for the dishes that I make including the ingredients, the amounts required, and the amount I have on hand. I would like to be able to quickly see what dishes I can prepare based on the ingredients I currently have in my pantry. Is this possible? MembersI'll show you how to look at the actual quantity of the products you have on the shelf and calculate if you have enough to make a dish. Instead of just "yes, I have eggs" you can say "I have 12 eggs" and calculate accordingly. Additionally, in Access Developer 19, I expand on this topic even more and show you how to do it with recordsets, and how to click a button to make a meal and remove the product components from inventory.
Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the database template from class plus get access to the Code Vault. If you signed up on YouTube you have to register on my YouTube Find User page so I can set up your account here on my web site. If you're not a member, Join Today! Links
|
||||||||||||||||||||
Check out these other pages that may be of interest to you: |
|
| |||