kapitaen

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

Chris

 

 

fmp a 13.0, osx 10.11.1

Outcomes