Hi,
I need some help with filtering.
I have a Choice field called Classification.
Depending on the Classification chosen, I want to only return the possible Grades they can choose from.
I then want to show the corresponding pay rate in another field.
So if I select B from the choice field, Grades Cs1 and CS2 are available to choose from. If I choose CS2, another field is populated with $30.
Thanks for your help.
Classification | Grade | Pay Rate |
---|---|---|
A | RE1 | $20 |
A | RE2 | $30 |
B | CS1 | $20 |
B | CS2 | $30 |
C | CA1 | $20 |
C | CA2 | $30 |