Multiselect based off another multiselect
I have a list of contractors, each of which has multiple employees.
I also have projects assigned to the contractors, some projects have more than one contractor -- what I am hoping to accomplish is selecting multiple different contractors from a lookup in the project form, then filter another lookup of the contractor employees, based on the contractors selected.
Is this possible? Or is there a better way to accomplish this goal?
Thanks,
Chris