Thanks. I've got all this working; will let you know if they want it as a dropdown.
Now of course, they decided they want multiple team members as well as multiple contacts outside the company -
I have that all working but there is a twist - instead of restricting outside Contacts to the company they work for (which I have working as a classic Conditional Dropdown) I now want to restrict the Team Members seen to Current ones (which is a checkmark field on the Team Members Table), and which I've added to the Relationship Table as well.
When I go to Related Team Member to set the Conditional Values field in Reference Field Options,
I want to say "The Values in this field depend on a selection in another field - Show Only Team Members where Team Member Current = Yes."
But the only option is Show Only Team Members related to some other field (not "Yes" in a field).
How to restrict these values in a dropdown by some feature in the same record? (In this case, whether they are current or not?)
------------------------------
Charlotte
------------------------------
