simple list confusion

[Joel Saltzman]

I have a list of category codes and their meanings. Such as:

rv-essentials Main Essentials

I want to have a checkbox setup with all the meanings and when the meaning is checked it puts the category code into a field.

How would I do that?

[aldipalo]

Without a more complete explanation as to what categories and what category codes a quick answer would be a calculated field with a case statement.

Case(:category = "A"; "1";

::Category = "B";2;

::Category = "C";"3";

)

Of course hard coding can present problems in the long run. If Category B = 4 at a later date you would have to recode the case statement.

You could also set up a conditional value list.

Do a Search for CONDITIONAL+VALUE+LIST and you will get many example how to set it up.

HTH

Al

[Joel Saltzman]

THANKS! I forgot to mention that the valuelist field will have more than one check box. So, when two options are checked, I would like the category field to show both references. Such as

check box field has:

Essentials

hoses and chemicals

both checked and the category field would show:

Essentials001,Essentials002

Does that help?

Edited January 25, 2007 by Guest