Two subforms referring to the same table.

B

Ben

I am having trouble displaying data in a form the way that I want it to.
This is what I would like to see on the form:

-------
Recipe produces: [Subform with list of ingredients the recipe produces]
Recipe uses: [Subform with list of ingredients used to produce the above]
Various other recipe details contained in the recipe table not linked to any
other table
--------

Ignoring non linking fields, I use the following tables and fields:

TblRecipe
RecipeID
TblIngredient
IngredientID
TblUses
UsesIngredientID
UsesRecipeID
TblProduces
ProducesRecipeID
ProducesIngredientID

TblIngredient.IngredientID is one-to-many linked to both TblProduces and
TblUses. (one on the TblIngredient side)
TblRecipe.RecipeID is one-to-many linked to TblUses and TblProduces. (One on
the TblRecipe side)

I have three questions for you kind folks:
Is the table design of the database ok for what I want to do?
If so how do I construct a query to base the form on?
Will the form wizard cope with what I am trying to do, or will I have to
create it from scratch?

I've tried several different alternatives, but can not work out how to
create the form above. Thanks in advance for any help!
 
Top