Hi there,
There seem to be a number of similar posts but not addressing my situation...
The key difference is, I want the list of multiple choice options to change depending on the user. Let me elaborate.
I have two objects - Member (who has Teacher specific fields) and Graduation. Teachers would submit Graduation Request using the Graduation object. In both these objects, I have a field named Instruments. Teachers will have multiple-selected instrument values (one may have violin and viola, whereas another may have piano and organ). The Instruments field contains a long list.
I suppose you already are getting to where my pain point is. In Graduation object when Teacher is ready to submit a request, the list of Instrument is a single-selection instrument value. However given there are different types of instruments that Teachers cater for, I wish to narrow down the list to basically restrict to those that the Teacher has associated with. This way, a Teacher certified for violin does not mistakenly requests for a graduation for piano.
However, to my knowledge, there is no way to 'map' the list of multiple choice options based on another object. Is there any way I can restrict piano teachers to submit violin graduations?
Please advise. 🙏🏻
Reference: other posts.