Calculation based on selected value list item?

[djeans]

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

[bcooney]

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

[djeans]

Thanks!!

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

Thanks again.

Darron