Recursive Help

[rivet]

Unfamiliar with creating custom functions, I would like to return the value list with a count beside each item

Let ( [

thelist = List ( diet::restriction ) ;

vlist = ValueListItems ( Get ( FileName ) ; "diet_restriction" ) ] ;

PatternCount ( thelist ; GetValue ( vlist ; 1 ) )

)

Inital List

No Pork

Vegetarian

Vegan

Return List

No Pork 3

Vegetarian 2

Vegan 8

[Vaughan]

Try this, I wrote it some time ago:

http://www.briandunning.com/cf/1027

[comment]

thelist = List ( diet::restriction ) ;

Why not summarize the diet table by restriction, using a summary field?

[rivet]

Thanks Vaughan, that did the trick. Comment I wanted the function to set a field.