Finished Product Database
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: