4 Replies Latest reply on Jan 21, 2010 2:42 AM by specpharm

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

    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!