Here's a hard one: portal to show all related records across multiple fields
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:
... 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!