Check Box- predefined based on record

[ssancton]

Hopefully someone can set me straight on this.

I've got a checkbox set for a field, using a value list.

I want to be able to predefine which items are checked off, based on other info from the record (i.e. Province)

In order to do this, do I need to create seperate fields for every check box item rather then using a value list?

Example... Poster types.

Value List:

Poster 1

Poster 2

Poster 3

Poster 4

etc...

If the Province is BC... I want Poster 1 and poster 4 to be checked off.

Thanks,

Scott

[mr_vodka]

Ssancton,

Just set the field if doing it by script.

If Province = "BC"

Set Field [checkbox; Poster 1 ¶ Poster 4 ]

EndIf

If you want to do it by a value in field, then in your field that uses value list as checkboxes...

Create a calculated value.

Case ( Province="BC" ;"Poster 1 ¶ Poster 4";Province="QB" ; "Poster 3"; Poster 4 )

Make sure 'Do not replace value...' is unselected.

[ssancton]

Thanks Mr_Vodka,

Works great. The only issue I have is when it gets more complex, i.e. having to overwrite a previous Case based on other variables(Using the non-scripted version).

I'll play with it as time goes on though, you helped me get much closer.

Thanks again.