Dependent Dropdowns - Many to Many
Is there a way to enable a many-to-many relationship on dependent dropdowns? If so, how do you do this?
To provide some context, I have two lists:
Employees can belong to many departments. (Currently have a module which assigns employees to departments using two dimensions, employees and departments, and a boolean line item.)
Departments has selective access enabled.
I have a module for labour input. I would like users to be able to enter the module and assign an employee to a department - however I would like to limit that choice to only those employees who belong to the relevant department. The labour input module has a department line item which shows the relevant department - screenshot below.
Any help would be greatly appreciated!