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.
Thanks for your reply - I was really hoping that there would be a way to manage this without imports. If there is, or if you have any other suggestions then I am very open to them.
I believe there is a slightly simpler way to process the import side. I created a list with two properties formatted to employee and department. This is my 'filter combinations' list. This can then be imported to straight from the employee matrix module without the need for additional line items. The only exception to this is the anaplan ID of the employee list. As the employee list is numbered, it is not possible to import the display name to the list, instead you have to reference the list item name using NAME(ITEM(Employees)).