Related, many to one

Discussion created by LambdaEnt on Oct 22, 2017
Latest reply on Oct 22, 2017 by Orlando

I have a table (Formula) with records listing ingredients:

     Formula Name, Ingredient 1, Ingredient 2, Ingredient 3


Another table (Ingredients) has records with some static amounts:

     Ingredient Name, Typical Min Qty, Typical Max Qty


How can I make the amounts Typical Min Qty and Typical Max Qty display for each Ingredient in the Formula records? I'd refer it not to be copied into Formula records.