I have this field in my French-Canadian ParentList: 'Gender', with 'Male' and 'Female' as choices.
I have another field in this French-Canadian ParentList: 'Position', which is a look-up field to a ChildList.
Why do I specify 'a French-Canadian' list? Because if I would be lucky enough to be born in a place like France where the position titles are always on the "masculine" flavor whether for women or men, I would not be asking this question now. My problem is, apart the fact my parents thought Quebec as a decent place to have kids, SOME elements in my ChildList are usable only for women, some only for men and some for both. Like this:
Of course, I want my Look-up drop-down list to show only the right elements, depending on the gender.
- I thought of using a calculated column, but it is more complicated than "if this is true, show it. Otherwise, don't show it".
- I thought of using Codeplex's 'SharePoint Filtered Lookup Field', but since it had not been edited since 2009, I hesitate a lot.
- I thought of using Codeplex's 'SPServices.SPCascadeDropdowns', but since some of my child elements can point to two elements, I foresee a bug.
- I can not use InfoPath or other 3rd companie'$ $olution$. I can use SP Designer and some imagination for a work-around.
- Is it possible for a look-up field to point to another list if...? (Like use 'Female list' if Gender='Female' otherwise use 'Male list')
- Maybe a workaround would be 1- to get rid of the yes/no columns for each element and instead, 2- to have a 'male title' AND a 'female title' and choose accordingly?
What would be the best approach?