AnsweredAssumed Answered

Here's a hard one: portal to show all related records across multiple fields

Question asked by specpharm on Jan 20, 2010
Latest reply on Jan 21, 2010 by specpharm

Title

Here's a hard one: portal to show all related records across multiple fields

Post

Okay so our company are making up compounded mixtures from different ingredients - and I want to be able to track the amount of any one ingredient that's been used. The layout for a new mixture contains fields for up to five ingredients and their respective amounts. It looks like this:
 
Ingredient 1
Amount 1
Ingredient 2
Amount 2
 
... and so on (five repetitions)
 
I also have a table with an entry for each different ingredient. The ingredients field in the mixtures layout is a value list taken from this table. For each ingredient, I want a portal to be able to find every single incidence of the ingredient in the fields mixtures::ingredient 1/2/3/4/5 and their respective amounts.  
 
This is honestly driving me crazy (I bet you hear that a lot!) I've been stuck on this one all day and I'm getting nowhere. Of course I'm sure it's a cinch to an FM pro.
 
Thanks to anyone who can help! 

Outcomes