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!