Hi all,
I've been asked to write a 'small' database for our kitchen staff. It was initially a simple inventory db, which I've created. I suggested that a recipe system could be incorprated into the databse - major problem.
I'm trying to create a form that basically contains groups of ingredients i.e. canned foods, vegetables, herbs etc and I then want to have a quantity field associated with that ingredient where you can put a number in to indicate the amount required. If the recpe requires 5 x 500g tins of tomatoes then you'd enter 5 in the field. I can do this as a static form but would like to do it more dynamically as new ingredients are added to the database. Finally once youve created your recipe you can click on a button to subtract the quantities from the current stock and print off or display a recipe. The part I'm stuck on is creating a list of ingredients and include a quantity field that can be altered. Ideally this recipe can then be saved and recalled again at a later date.
I can just leave this as an inventory system, but I'd like to tackle the recipe side as well. Any pointers would be greatly appreciated.
Keith
I've been asked to write a 'small' database for our kitchen staff. It was initially a simple inventory db, which I've created. I suggested that a recipe system could be incorprated into the databse - major problem.
I'm trying to create a form that basically contains groups of ingredients i.e. canned foods, vegetables, herbs etc and I then want to have a quantity field associated with that ingredient where you can put a number in to indicate the amount required. If the recpe requires 5 x 500g tins of tomatoes then you'd enter 5 in the field. I can do this as a static form but would like to do it more dynamically as new ingredients are added to the database. Finally once youve created your recipe you can click on a button to subtract the quantities from the current stock and print off or display a recipe. The part I'm stuck on is creating a list of ingredients and include a quantity field that can be altered. Ideally this recipe can then be saved and recalled again at a later date.
I can just leave this as an inventory system, but I'd like to tackle the recipe side as well. Any pointers would be greatly appreciated.
Keith