J
Jace Campbell
For my program, you enter your own ingredients with prices and then build a
menu item from the ingredients. I have one table is related to the
ingredient name from one table and the menu name from another. The costs for
the individual ingredient in the menu item are then calculated using a query
and summed on the report or form. This gives you the total cost of the menu
item.
I would like for someone to be able to add a menu item that is already
created to another menu item to make combos, without having to re-enter the
first menu item.
For example, you have ingredients for a hamburger and build the hamburger.
Then you have the ingredients for and build a menu item for french fries.
Then I want to make a combo basket of a hamburger and french fries.
The problem is that the sum of each of the items is not stored anywhere, it
is only calculated when the item is selected. Also, when building the menu
select the ingredient from a combo box that has my ingredient table as the
record source. So how it is now, you wouldn't be able to select another menu
item as an ingredient.
I am pretty sure that this is a flaw in the original design of the database
in how I setup the tables, but I would appreciate many more second opinions
and suggestions as to how to tackle this problem. Below I have shown my
relationships for further reference.
Ingredients Middle Menu Items
ing_name
menu item from the ingredients. I have one table is related to the
ingredient name from one table and the menu name from another. The costs for
the individual ingredient in the menu item are then calculated using a query
and summed on the report or form. This gives you the total cost of the menu
item.
I would like for someone to be able to add a menu item that is already
created to another menu item to make combos, without having to re-enter the
first menu item.
For example, you have ingredients for a hamburger and build the hamburger.
Then you have the ingredients for and build a menu item for french fries.
Then I want to make a combo basket of a hamburger and french fries.
The problem is that the sum of each of the items is not stored anywhere, it
is only calculated when the item is selected. Also, when building the menu
select the ingredient from a combo box that has my ingredient table as the
record source. So how it is now, you wouldn't be able to select another menu
item as an ingredient.
I am pretty sure that this is a flaw in the original design of the database
in how I setup the tables, but I would appreciate many more second opinions
and suggestions as to how to tackle this problem. Below I have shown my
relationships for further reference.
Ingredients Middle Menu Items
ing_name