We have a video db that was converted from an old DOS program. One field is called "Level" and contains any combination of the following: P, I, JrH, SrH, A . If a video is good for the whole family it will contain ALL those letters. If it is specifically for High School it will only have "SrH".

I'm preparing to combine this new db w/another one (for books) and i'd like to take this field and make it into a check-box field (which would be easier for us to search).

I've created a field "Level Copy" and tried to make it a calculation using the Case command [Case(Level = "P", "Primary", Level = "I", "Intermediate",) etc.

unfortunately, it didn't work. I made it a text field and tried to write a script that would work, but no luck.

basically, i'd like the program to look at the original Level field and mark the corresponding check-boxes in the Level Copy field (then i'll delete the Level field).

any ideas on how to go about this?

You can use a looping script to set another text field up for display as a checkbox field. The important thing to remember is that multiple values in a checkbox field are stored as each value separated by a carriage return. The script might look like:

Show All

Goto Record/Request/Page(first)

Loop

SetField(NewText,

Case(PatternCount(OldText, "P"), "Primary" & "

thanks BD.

not only was that helpful, but I learned a lot too.

works great! thanks!

dan

ps. the carriage return symbol did come through.