Dynamic multiple choice options based on value from another field
I have two multiple choice fields on the same table.
Each record has a required field called "Program Type," and an optional field called "Scope." There are three program types that will use the scope field, the rest won't see this field when viewing or editing these records on the form.
Each program type has a different set of choices they can use within the "scope" field. I would like a way for the form to show only the appropriate options to when the "program type" field is set to these unique values. I am still using old forms on this table.
Example of what I would like the drop down to show based on program type.
Program Type 1
Scope A
Scope B
Scope C
Program Type 2
Scope D
Scope E
Scope F
Hopefully that's clear, thanks for any advice you may have!
Jen
--
I know I have done this other places in my sy
------------------------------
Jen Black
------------------------------