A
AR
Here are my tables:
Subform of Mixing: MixingIngredinetsSubform
Subform of Product: Mixing
Main Form: Product
In the MixingIngredientsSubform, I need to pull up all
ingredientcodes for that product code. Also, I need to
link the MixingIngrdientssubform to the Mixing subform by
Mixing ID.
Now, I link between Mixing and MixingIngrdientssubform is
working fine, but instead of getting a list of just the
ingredients for that particular product code, I am getting
a list of all the ingredients. How do I set criteria to
specify that I only want the ingreidents for a particular
product code to pull up.
Thank you.
Subform of Mixing: MixingIngredinetsSubform
Subform of Product: Mixing
Main Form: Product
In the MixingIngredientsSubform, I need to pull up all
ingredientcodes for that product code. Also, I need to
link the MixingIngrdientssubform to the Mixing subform by
Mixing ID.
Now, I link between Mixing and MixingIngrdientssubform is
working fine, but instead of getting a list of just the
ingredients for that particular product code, I am getting
a list of all the ingredients. How do I set criteria to
specify that I only want the ingreidents for a particular
product code to pull up.
Thank you.