Subform linking quesitons

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top