I'm trying to integrate two parent lists into one cascading list, which means,
I have a parent list called "Groups" contains ('DBA','SA','ADMIN','OPERATIONS')
i have another parent list called "Servers" contains ('SRV1','SRV2','SRV3','SRV4','SRV5')
I have a child list called 'Accounts' which will be determined based on the above two parent lists on individual conditions:
If SRV1 then Accounts will show 'SYS1','SYS2'
If DBA then Accounts will show 'SYS1'
If DBA & SRV2 then Accounts will show 'SYS3','SYS4','SYS5'
if DBA & SRV3 then Accounts will show 'SYS5'
The child list setup is as follows:
Title Group Server
SYS3 DBA SRV2
SYS4 DBA SRV2
SYS5 DBA SRV2
SYS5 DBA SRV3
In the cascading list, Group and Servers are independent lists and no cascade drop down relation between them.
Is it possible to introduce something like this?
relationshipListParentColumn: "Group, Server",
parentColumn: "Group, Server",
My problem is how to introduce multiple parent columns into the cascade drop down.
Any idea would be great.
Dec 20, 2010 at 2:00 PM
SPCascadeDropdowns isn't going to get you what you want here, though you could probably build on it. However, if your value relationships are going to be relatively constant, you might just want to build your own jQuery logic for this. You have few
values, so the dropdowns will all be simple selects. You could simple store the values in your code.