Hello,
I'm creation a recipies management file, The recipies are build upon small recipies put together so this is what I have:
- Main Table "Indice Formulas" contains general information of recipies and should be used to select small recipies
- Standard Recipies Table "Tratamientos STD" should be used to pull the products and quantities of the small recipies
- Table "Cantidades" with products and quantities that each main formula uses ( all small recipies for each main recipie"
I have set up a form with the main table and a subform of "cantidades", and linked them toguether, but i do not know how to pull the information from one table to the other.
attached my tables and relationships.
Thanks for the help.