List calculation in field help needed by someone smarter than me.

[alphanitrate]

I have a text field that has a "list" calculation set up in it. It works great - however to make the data show up in this new field i need to recheck a check box to have any content initially show up.

My question is: Can I "refresh" these boxes so that they have the list info put into that field?

I have 30,000 records so i'd prefer not to do them one by one.

[alphanitrate]

Here's the calculation I am using.

List ( za__bulletEnglish01_p;za__bulletEnglish02_p;za__bulletEnglish03_p;za__bulletEnglish04_p;za__bulletEnglish05_p;za__bulletEnglish06_p;za__bulletEnglish07_p;za__bulletEnglish08_p;za__bulletEnglish09_p;za__bulletEnglish10_p;za__bulletEnglish11_p;za__bulletEnglish12_p;za__bulletEnglish13_p;za__bulletEnglish14_p)

One further thought is that it would be ideal if i could add a bullet after the end of each return so the items would show up like:

•

•

•

I tried adding a &"•" before each field but it is looking for a (

Could I write a script that would select those boxes with checks, uncheck them and have filemmaker keep track and recheck them?

The fields listed above only get content when the other fields are checked

[mr_vodka]

Seem that me that you may need to change your structure. Once you have repeating types of fields such as za__bulletEnglish01_p, 2, 3, etc you really should be looking into a related table.