I couldn't find the exact answer to this question on the boards, but hopefully one of the experts here can help.
I am working on an automated form for some of my trainers. Within the form, I have a drop down box with 23 different selections (this is for termination reason codes such as ATT for attendance, JOB for Job Abandonment etc.)
When one of the 23 selections is chosen, I need a field to select one of 5 different options (Termination Voluntary, Termination Involuntary, Verbal Counseling, Written Counseling or Final Warning.)
The issue I am running into is the rule that you can only have 7 IF statements in the formula. I don't want to create multiple fields if there is another way around it.
Could anyone lend assistance?
Thanks,
Erich
I am working on an automated form for some of my trainers. Within the form, I have a drop down box with 23 different selections (this is for termination reason codes such as ATT for attendance, JOB for Job Abandonment etc.)
When one of the 23 selections is chosen, I need a field to select one of 5 different options (Termination Voluntary, Termination Involuntary, Verbal Counseling, Written Counseling or Final Warning.)
The issue I am running into is the rule that you can only have 7 IF statements in the formula. I don't want to create multiple fields if there is another way around it.
Could anyone lend assistance?
Thanks,
Erich