Calculated Value List

[Raschelle]

Hi,

I would like to create a value list based on a calculation so that the list only shows the classes available to an employee based on which classes they are allowed to take. There are fields in the employee info db for each training with Yes or No marked as to whether they need to take the class.

My thought was to create a calculation field to display only the classes marked as yes and then make a value list based on that field.

I used this calculation for the field:

If ( RTK = "Yes" ; "1" ; "" ) &¶ & If ( Waste Handlers = "Yes" ; "2" ; "" ) &¶ & If ( Back = "Yes" ; "3" ; "" ) &¶ & If ( Eye = "Yes" ; "4" ; "" )

However, the value list always shows "1", even if that class isn't checked (for example, if classes 2 and 4 are checked, the list shows 1, 2 and 4).

Any suggestions? Thanks!

Edited June 15, 2010 by Guest
Updated info on problem

[Raybaudi]

A value list gets its values from a field of ALL the records of the DB... ( w/o any filter )

So it pretty sure that one record has 1 checked.

[Raschelle]

Shoot! You're right. Any suggestions on how to accomplish the value list I need, since a calculation field won't work?

For each employee the value list displayed should have only those classes they need to take.

Thanks!