Hi There

Need some help with this

Looking for a custom function. that does this

field 1 =

jim

sally

susan

dave

-------------------------------------

the output should be

jim

jim sally

jim sally susan

jim sally susan dave

sally

sally susan

sally susan dave

susan

susan dave

dave

Any help would be appreciated. I did this in a script but it was way to long and I felt that a recursive function would be alot shorter

Thanks Again

Stu

It sounds like you need something similar to

http://fmforums.com/forum/showpost.php?post/355528/

(if you are using this as a relationship key, the duplicates won't be a problem)

or

http://fmforums.com/forum/showpost.php?post/354242/