Help setting up database correctly

Need help Database
1

Hi all, would anyone have thoughts on how my database should be setup in the following application?

3 data sets
Product, Recipe, Ingredient

Product fields:
Name (text)
Description (text)
Cost (number)
Recipe (Recipe)

Recipe fields:
Name (text)
Ingredients (list of Ingredients)

Ingredient fields:
Name (text)
Amount (number)
Unit of Measurement (option set)

This seems basic but I cannot seem to get the Recipe/Ingredients setup properly. Each recipe will have multiple ingredients and each ingredient attached to the recipe will have the Amount and Unit of Measurement attached to it and user editable. How can I setup the database properly to achieve this? Thanks.

2

Product fields:

  • Name (text)
  • Description (text)
  • Cost (number)

Recipe fields:

  • Name (text)
  • Product (Product)

Ingredient fields:

  • Name (text)
  • Amount (number)
  • Unit of Measurement (option set)
  • Recipe (Recipe)

The Ingredients are from a Recipe.
The Recipe is from a Product.