Monthly Archives October 2012

Custom Function for Filemaker: Find Matches in 2 value lists

In a Filemaker database, I had to come up with a quick way to find out which values in array myitems also exist in array list1 and array list2. For this, I created the following function: _FindMatchesInTwoValueLists(list1,list2,start,myitems) This is the function – as you can see, it’s recursive. The variable “start” is usually 0 when […]