I would like to set up true cascading drop downs that limit selections based on previous entries in the same lookup field. Here is the example:
Client Name - this field indicates the drop down in the field Client Primary Contact
I need to create additional contact options that would include:
Additional Contact - pulling from the client name without including the contact chosen in Client Primary Contact
Additional Contact 2 - pulling from client name without including the contacts chosen in Client Primary Contact and Additional Contact 1
Is this type of cascading drop down possible? I would assume it could work if you could add more than one condition to a field, but I do not see how to do that.