How do I reference a selected check box item in a calculation?

For instance, I have a value list with two items, one is "linked" the other is "master" I have another field that I would like to perform a calculation if master is checked, and if only linked is checked, then put in a looked up value.

This is probably easy to do, but I can't seem to figure it out.

Thanks

Darron

The field that is assigned the value list will contain a return-delimited list of the checked values. So, if "linked" is checked and "master" is checked, the contents of the field will be:

linked

master

you can see this by putting the same field on your layout and format it as an Edit box.

So, the dependent field's calc would be a case statement:

case (

myField = "linked" ; Lookup (relationship::field);

myField = "master" ; calc you require;

valuecount (myField) =2, "what you want to happen if both are checked"

) //end case

hth

Thanks!!

I knew it has to be possible, just couldn't figure it out.

Thanks again.

Darron