In a many-to-many relationship, how to find records that relate to two specific items?

[ChristophL]

I would appreciate some help if anyone knows how to solve this. 

I have a database with three tables. The first is a Recipe table, with fields RecipeID, RecipeName, etc. The second is an Ingredient table, with fields of IngredientD, IngredientName, etc. The third is a RecipeIngredient table that joins the above tables together, with fields of RecipeIngredientID, RecipeID that links to the Recipe table, IngredientID that links to the Ingredient table, Amount, etc.  The three tables form a typical many-to-many relationship.

I have been trying to figure out how to find a recipe that contains two specific ingredients.  For example, I tried the Criteria “RecipeIngredient::Ingredient: [Carrot] AND RecipeIngredient::Ingredient[2]: [Potato], but it didn’t work. Any suggestions? Thanks in advance!

[comment]

See if this helps:
https://fmforums.com/topic/105273-searching-related-data-with-and/?do=findComment&comment=476391

 

[ChristophL]

I tried it, and it works great!  Thanks a lot! 🙂