Hi all,
The form Menu is a subform of Food Categories. While Menu and Food Categories are linked, Menu is further linked to Food Ingredients in a one to many relationship. Basically what am trying to do is be able to click on a button next to a dish name in the Menu form and the ingredients for that dish will pop up.
The way I am currently doing it is by using a macro with a Where Condition of:
Forms![Food Ingredients]!Menu_ID=Forms![Food Categories]!Menu.Form!ID
So that only Food Ingredients entries who's matches that of the Menu ID will be listed. However, so far it doesn't work.
Any help would be greatly appreciated!