function list (field), howto get unique values?

Discussion created by kapitaen on Nov 5, 2015
Latest reply on Nov 5, 2015 by kapitaen

Hi all,

i have three tables "recipes", "cross_recipe_ingredient", "ingredient"


Inside ingredients i have a field "attrib", which is filled from a value list which contains "kosher", "halal", "vegetarian".


when i make a calculated field inside recipes, attribs_from_ingredient (list (ingredient::attrib)), yes it will contain all attribs the ingredients have.


But when two or more ingredients have the same attrib, this will appear in recipe::attrib double, or even more.



How can i make the calculated recipe::attrib to contain unique values, whithout the need for scripting?


Thank you!


greetings from germany




fmp a 13.0, osx 10.11.1