SubForm?

[tlindeman]

I am building a recipe database. I would like to create a form where the user enters an ingedient, so I setup a table with ingredient 1 through Ingredient 10. I only want the choice for ingredient 2afteringredient 1 is entered,and ingredient 3 after ingredient 2 is entered. Etc. How do I do that.

Thank YOu
TOny

 

[boblarson]

First thing is to fix your table structure. You should NOT have repeating fields (ingredient1, ingredient2, etc.). Those should be ROWS in a table not columns. Your current structure is not normalized and if properly normalized you should be able to handle ANY number of ingredients. So typically the table structure would be something like:

tblIngredients
IngredientID - Autonumber (PK)
IngredientName - Text
IngredientTypeID - Long Integer (FK from IngredientTypes table)

tblIngredientTypes
IngredientTypeID - Autonumber (PK)
IngredientType - Text

tblRecipeHeader
RecipeHeaderID - Autonumber (PK)
RecipeTitle - Text
CookingTypeID - Long Integer (FK from CookingTypes table)
CookingTime - Long Integer (for storing cooking time in minutes)
CookingTemp - Integer (for storing cooking temperature)

tblCookingTypes
CookingTypeID - Autonumber (PK)
CookingType - Text ' things like Wet, Baked, Roasted, Raw, Broiled, etc.

tblRecipeDetails
RecipeDetailID - Autonumber (PK)
RecipeID - Long Integer (FK)
IngredientID - Long Integer (FK)
Quantity - Integer
UnitOfMeasureID - Long Integer (FK from tblUOM)

tblUOM
UnitOfMeasureID - Autonumber (PK)
UnitOfMeasure - Text (like Tablespoons, Teaspoons, Cups, etc.)
UnitOfMeasureAbbrev - Text (like tbsp, tsp, cup, etc.)

So the recipe details is where you would store all of the ingredients and it would not be limited to 10.

 

[tlindeman]

Thank you for your help.

Tony