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

    function list (field), howto get unique values?

    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

      Chris

       

       

      fmp a 13.0, osx 10.11.1