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.