AnsweredAssumed Answered

Finished Product Database

Question asked by inker on Nov 4, 2013
Latest reply on Nov 4, 2013 by philmodjunk

Title

Finished Product Database

Post

     Hello FMP Gurus!

     I am needing a database that will house information for a Finished Product.  The finished product uses one (of many) recipes, and a recipe uses many ingredients.  

I have the Recipe >------< Ingredient relationship working fine via a join table.  It shows each line of the recipe with the correct amounts.

However, I am stuck on the Finished Products table.  I need it to display all of the ingredients for a recipe too, but it will also need to hold information for each ingredient that is specific to that finished product.  Because many finished products can contain the same recipe, but they will vary on size (think different sizes of potato chip bags).  

     Here is a straw man version of my file in hopes this explains the situation a little better:

     https://dl.dropboxusercontent.com/u/7530915/simplified%7Erecipe%7Edatabase.fmp12

      

Screen_Shot_2013-11-04_at_11.28.28_AM.png

Outcomes