HI,

I have one text field that has one word in it. (this is a global field)

I have another field which has a value list in it set up as checkboxes.

I have a third field that holds the result of the comparison.

Each record will have at least one box checked, but may have more or even all of them checked.

For each record i need to compare the text field to the value list field. If the word is checked in the value list field, i need a third field to be marked with something (yes or 1...). If the word is not checked in the value list field then i want the third field to be empty (or produce a 0).

I hope i have explained this properly. I have tried various calculations/ functions and scripts and can't seem to get a working result.

A calculation field (result is number) =

not not Position (

checkboxes.fp7.zip

Well this calc' does it:

Substitute ( PatternCount ( theBoxes ; theGlobal ) ; "0" ; "" )

...but since the resulting field can't be other than unstored, will it be tough to search in since the search are bound to be unindexed. So a much better way to handle it is to selfjoin relate theGlobal field with theBoxes and let a script make a GTRR(SO) to single to records out that have a checkbox chosen that matches.

--sd

To Comment:

I looked at your file, but could not quite work out how i could use it, but thanks.

Soren:

Brilliant. It worked as you said it would, and my problem is now fixed. Thank you!