Jump to content
Sign in to follow this  

Recipe Used in a Recipe

Recommended Posts

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?

Share this post

Link to post
Share on other sites

See if this helps:


Share this post

Link to post
Share on other sites

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.

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

Sign in to follow this  


Important Information

By using this site, you agree to our Terms of Use.