I have the following lists:
2: - Title
4: - Title
5: - MainTasks (lookup to MainTask: multi select)
7: - Title
8: - Department (lookup to Department)
9: - MainTask (lookup to MainTask)
When I create a new Task I want the selected Department to filter the possible MainTasks that are linked to the selected department (line 5). After a setup with columns, adding script files and create a custom new form, I only get the first entry for Maintask
for a selected department that has many assigned MainTasks and a blank MainTask dropdown if the selected department har no MainTask.
Is this scenario possible with the existing 'Cascade Dropdown' function?