Relationship question

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

I have 3 tables:






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.