AnsweredAssumed Answered

Relationship problems? or Do need the right tool for the job?

Question asked by darevalo on May 22, 2017
Latest reply on May 26, 2017 by beverly

Hey everyone. I'm new to FM and have not yet come to dive into queries and scripting. Any help or direction would be greatly appreciated. My dilemma is as follows:

 

As simply as it comes to me, I have allergens (from allergensTbl) which are an attribute of an ingredient (in ingredientsTbl). Ingredients form formulas in my formulalineitemTbl (Child  to formulasTbl) which are used to form product items (in productitemsTbl). The formulalineitems is a portal in the formulas layout and displays an allergen there if an allergen is present. However, I want the allergens to appear in my production Items layout without repeating themselves . I can do this as a portal but it leaves line spaces and may duplicate allergens. I just want a brief statement of allergens in that one record (i.e.: [Correct: Contains: Milk, Soy] [Incorrect: Contains: Milk, Milk,  ,Soy]).

 

What's the best way to accomplish this?

 

Thanks in advanced to all you incredible minds.

Outcomes