3 Replies Latest reply on Nov 5, 2015 6:43 AM by kapitaen

    function list (field), howto get unique values?


      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