TKnTexas Posted August 21, 2012 Posted August 21, 2012 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?
comment Posted August 21, 2012 Posted August 21, 2012 See if this helps: http://fmforums.com/forum/topic/75993-manage-data-from-table-to-new-table/#entry360129
TKnTexas Posted September 25, 2012 Author Posted September 25, 2012 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.
Recommended Posts
This topic is 4503 days old. Please don't post here. Open a new topic instead.
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 accountSign in
Already have an account? Sign in here.
Sign In Now