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.