I have a food cost app with three primary tables: Inventory/ingredients, recipes, menus. Where I am stuck is when a recipe needs to be used in another recipe.

In the recipe table there is a portal to recipe_child which are ingredients. I want another table back into Recipe_parent. Here are a couple of examples:

Hamburger: 4 oz Hamburger

1 ea Bun

1 ea Condiments

Cheeseburger: 1 ea Hamburger

1 sl Cheese

ChiliBurger: 1 ea Hamburger

2 oz Chili

I have a Recipe TO related to Recipe2 TO with the Portal to look in Recipe2. That is not working. What am I overlooking?

See if this helps:

http://fmforums.com/forum/topic/75993-manage-data-from-table-to-new-table/#entry360129

That did help. But then other opportunities developed. I had to expand an inventory item so that the purchase size/qty is noted, then how it breaks down into an inventory level. Which then breaks down to the ingredient level.

Recipes need a usage unit. These are a lot of fields to be added since the record structure is the same item. I am still working through it. I have to flag inventory items vs assembled units so I can print count sheets.

And before I add an inventory item I search for the product SKU not being in the table already.