3 Table Relation

[Jon_4]

Sorry if this question is very basic, but i'm new to access and can't seem to figure out what i should do to be able to accomplish what i need.


I need to make 3 tables wich are related between them, one with Allergens, one with Ingredients and one with Dishes. One ingredient can have several allergens and one dish can have several ingredients.
I've already done the table with de allergens, and the table with ingredients with a Allergens field where i can select the allergens (IngredientsAllergens).
But what i can't do is have a table with the dishes, with the ingredients column and the allergens column, and be able to select the ingredients for a dish and populate automatically the field of allergens with the ones selected in the IngredientsAllergens table.

I know my english is not great but i tried my best to explain.
Thank you in advance.

[June7]

Don't have allergens field in Dishes. Just select ingredients. Then in a report build a query that joins tables so as to retrieve related allergens details.