I am trying to build one form that I can add to sub forms etc I just dont get it

[Wornout]

I have tried all sorts of ways,and they work up to a point,
I want 1 form that I can bring up a base recipe flavor(and can add new one to list) and a sub form lists all its ingredients and I can add to ,change,make new, and also bring up the variant flavor(and add new on to list) and a sub form that lists those Ingredients and I can add new, change add to and save the base to its table and the variant to and base recipe ID to a recipes table.The form I have now works but it saves the add too's to the next line so it make 2 entries into the recipes table from the variant.I don't mind if someone said to build a new form this way, as I have worked on this for weeks and am still not able to use it the way I need to. here are my tables

TBLBase Relationship with BaseRecipesTbl [BaseRecipeID]
[ID]Primary key Auto number,Yes(No Duplicates)[Name]Text

TBLBase Recipes Relationship with RecipesTBL[ID] and with IngredientsTbl [IngredientsID]and with Unit of measure TBL [ID]
[BRecipeID]autoNumber No PK,[Base RecipeID]Number,[IngredientsID]Number[UMID]Number[Quantity] Number

This is what I call a variant
RecipesIngredientsTBL relationship with RecipesTbl
[RecipeIngredientID] Autonumber PK [RecipeID] number [Ingredient] Number [Quantity]number [UM] number

Ingredientstbl relationship with RecipesTbl and with Base Recipestbl
[IngredientsID]PK Auto number,[Stock Codes Raw] Text[Ingredients]text[Sub Ingredients] memo [Additives] memo[Fat]text[SaturatedFat] text[Carbohydrates] text[Sugars] text[Sodium]text[Energy]text[Protein]text[Allergins] memo

Unit of measure TBL has a relationship with RecipeIngredientsTBL[UM] and base RecipesTbl [UMID]

Final and main one is the RecipesTBL it has relationships with all of them
[RecipeID]autonumber number PK [Flavour]Text[Type]text[Size]number[Base RecipeID]number

Phew and thats it :-) I can do my form if someone can change that. I am just at my wits end
my form has 2 combo boxs 1 for base recipe and one for variant and I can add to list on both, 2 text boxs for type and size and 1 subform baserecipe Ingredients that I can add to change or make new, and 1 sub form recipe ingredient that I can add to change make new as I said it saves the combo box(Variant) on one line and the subform changes/additions/new in the right place

[zmbd]

Let's see if we have the model correctly understood:
Starting with a basic cookbook concept.
You have a receipe for pancakes.
There is a the list of ingedents for this base receipe.
There is a set of instructions for this base receipe.
Under this receipe is an entry for variations,
Chocolate Chip:
This has the additional ingredents, substitutions, and further instructions.
Buttermilk:
same concept as the Chocolate Chip, just a variation on a theme.

Is this model correct in concept?

[Rabbit]

If what you are trying to do is to store a large n-tier hierarchy where you don't know how many levels there will be, I suggest using a modified preorder tree traversal algorithm. An example can be found here: http://www.sitepoint.com/hierarchical-data-database-2/.

You will need to modify their modified version of course. They have only one root node. Whereas yours will have multiple root nodes. So you will need to store a tree identifier with each node. You can add, delete, edit, amd retrieve the tree information the same way as in the article with the exception of adding an existing recipe. When you add an existing recipe, you will be basically making a copy of that tree and putting it in the new tree.

This is not an easy project to tackle. If you choose to go down this path, it will be very difficult. The upside is that it is one of the fastest ways to store a multi-tiered hierarchy of data where the number of tiers is not known beforehand. It also avoids recursion.

[Wornout]

Sorry Rabbit I have no idea what you are talking about. But what I did was start again and my new form was working untill 2 seconds ago. I had the sub form x3 that were run off queries on my main form they are all editable. on my main form I have 4 combo boxs each one a master field to the 3 sub forms everything was fine even to the point that I had code to be able to add new names to the combo lists then I added the last table and now I can not change the combo boxs.

[Rabbit]

Did you read the article I linked?

Why does this thread sound similar to your other one?