jjfcpa

Relationship question

Discussion created by jjfcpa on Aug 21, 2017
Latest reply on Aug 21, 2017 by philmodjunk

I have 3 tables:

 

Doughs

Formulas

Ingredients

 

The doughs is a one-to-many relationship with the formulas (for the doughs).

 

The formulas contain all the ingredients to create the dough; therefore, there is a many-to-many relationship with the ingredients.

 

I'm guessing I need a join table for the formulas and ingredients and just want to make sure I'm doing this right.

 

I want to have a dough screen where they can select a dough, see the formula for the dough on that screen in a portal and by selecting an ingredient in the portal see all the specifics for that ingredient.

Outcomes