A simple challenge suddenly becomes complicated

I have been requested to build a simple recipe database where a user may query by ingredient and receive a listing of all recipes that contain that ingredient. Or query by recipe and receive back all ingredients that complete the recipe.

The recipes need to be identified by a meal type (breakfast, lunch, or snack).

Every single ingredient is required to have one associative ingredient (ingredient = salt, associative ingredient = sodium).

My tables so far as follows:

tblRecip
RecipeID (pk)
RecipeName
MealID (fk from tblMeal)
MealName
Manufactor
ProductNumber
MainIngredient
Notes

tblMeal
MealId (pk)

tblIngredient
IngredientID (pk)
IngredientName

tblAssociativeIngredient
AssociativeIngredientID (pk)
AssociativeIngredientName

tblRecipeIngredient
RecipeIngredientID (pk)
RecipeID (fk fro tblRecipe)
IngredientId (fk from tblIngredient)
AssociativeIngredientId (fk from tblAssociativeIngredient)



Here is where I am having trouble:

A user interface (form) should allow the entry of a recipe, select in its meal type (from tblMeal) and populate other required fields from tblRecipe.

I need a subform (tblRecipeIngredients) that will allow the user to enter in ingredients and associative ingredients that will be linked to the recipe record they create. Those values should remain/be available for future recipe records (combo box/list?).

How do I link the subform? Within the tables, what do I use for the display control, row source type, and row source. I have tried various combinations and nothing seems to work.

I have attached the db. Any and all help is greatly appreciated.