How can I force select one of the choices of ...

(Eric) #1

How can I force select one of the choices of an enum, based on another choice from a different column?

To be more specific; I have two different enum column.

One of them lists different grades: 1st grade, 2nd grade, 3rd grade etc, all the way to 8th grade.

The second enum lists the book different grades work on: Book Level 1, Book Level 2, Book Level 3.

Now the way this works is that students from ‘1st grade-3rd grade’ work on ‘Book Level 1’.

Students from ‘4th grade-6th grade’ work on ‘Book Level 2’

Students from 7th grade-8th grade’ work on ‘Book Level 3’

How can I implement an action, where if I select a specific grade, it would automatically select the correct Book from the enum. For example, if I selected a student from 5th grade, it would automatically select ‘Book Level 2’. That way I would be able to make the book level enum hidden, and users wouldn’t have to select it because it would happen automatically.

If anyone has a tutorial or explanation, I would greatly appreciate it. Thanks!

(Steven Coile) #2

Looks like a switch() statement to me: - Conditional Expressions Conditional Expressions