Ask Your Question

Revision history [back]

Recipes.odbThere are various ways you can achieve this result. Most involve the use of a Macro but I have attached a database that does not require a Macro.

It uses a Table Filter that stores the Recipe selected from a List Box populated from the Recipes Table and then filters the Recipes to show in the Subform the ingredients for that Recipe. You can modify the quantity of an Ingredient, delete an Ingredient, or add an Ingredient. When adding an ingredient it has to be one that is already in the Ingredients Table. To add a new Recipe add it to the Recipes Table then you can add the ingredients through Recipes Form. Clicking on the IDIngredient column in the Subform will open a List Box showing all the Ingredients so it can be selected by name.