Find/Replace in checkbox value list

[jef chippewa]

hi, i want to compile a number of separate fields defined to appear with checkbox, and each having only a single value (eg. field S1 containing value S1, field S2 containing value S2, field S3 containing value S3...), into a single new field "publications" i have created using the list of values (S1, S2, S3...) defined to appear as checkboxes. i do a find for values S1 in field S1, and check the S1 box in the new "publications" field, then replace (cmd-"=") to set the value S1 in "publications" for the found records.

i try to do the same for the value S2, but this doesn't seem to work, the replace asks if i really want to set the value "S1" for all found records...?

doing the compilation manually isn't an option, because a search for any one of the "S" values brings up (a different set of) 500+ records.

jef

[QuinTech]

Hi, jef, and welcome to the Forums!

It sounds as if you are not actually trying to replace contents in field S2 in the second case, but instead trying to replace contents in field S1.

The way the replace command works is that, when replacing in the field "FieldOne", you will have three options: Replace with [a specific value], Replace with serial numbers, or Replace with calculated value. Now, the value of [a specific value] will be determined by the contents of the field in the currently-selected record. So it sounds as if you are, in fact, going into the field named "S1" and doing a replace there, rather than in S2.

Check that you are in S2, and used the "Replace with calculated value" option to replace contents with "S2".

HTH,

Jerry