Need some help

[laker_42]

I think this should be a simple script and I am pretty sure that I have done it before but I can't remember how to do this. I have one central database with one field. I have this field formatted as a check box list with three fields available to check. Each field corresponds to a separate database file. In each file I have a script that simply creates a new record. What I want to happen is for the user to check the boxes that they want to create a new record in and then hit a button that is attached to a script. I want this script to check to see what is checked and then fire the external script in the corresponding database. The script that I have in the central database is a series of 3 If statements. They check to see if one of the fields is checked, if so then fire the correct external script. Then there is an end if and then the second If statement. This seems like it should be really simple but I haven't been able to get it to work. Do I need to spell out every possible combination in nested If statements? Or does anyone else have a suggestion as to how I can accomplish this? Thank you for your help!

John

[LiveOak]

What you describe should work, assuming you've implemented everything correctly.

If (PatternCount(Field, "A"))

Perform Script (External, file A)

End If

If (PatternCount(Field, "B"))

Perform Script (External, file

End If

If (PatternCount(Field, "C"))

Perform Script (External, file C)

End If

You have to use PatternCount() to test the field as it won't equal each choice, only contain it along with other choices. Remember, checkbox fields just cause the entry of multiple choices separated by carriage returns.

-bd