Generating a list

[Heathbo]

Say I have 20 records, each with the name of the record and a field with the name of some fruit in it. Of the 20 records only 5 have the word Apple in the field. How do I get the names of those 5 records into a calculation field?

[aaa]

Helo Heathbo! Is this your good idea solution? See attachment.

Value_List.zip

[Heathbo]

Thanks for the help. I don't know what the good idea solution is. I'm not sure what the ValueListItems function does. And how is the field Your_Calculation coming up with those numbers in the list? Sorry, I'm still new to many advanced calculations.

[aaa]

See how i create Value List - using relation. Read about ValueListItems function in the help.

I not understanded, this is not your goal?

[Heathbo]

Got it. Thanks a bunch.

[-Queue-]

Make sure the calculation is set as unstored or else it will not update.