SPCascadeDropdowns with multiple parent columns

Dec 20, 2010 at 7:44 AM

Hi,

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:
for e.g.:
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
--------------------------------------------------
SYS1                 DBA           
SYS1                 SA
SYS1                                            SRV1
SYS2                                            SRV1
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?

$().SPServices.SPCascadeDropdowns({
relationshipList: "Accounts",
relationshipListParentColumn: "Group, Server",
relationshipListChildColumn: "Title",
parentColumn: "Group, Server",
childColumn: "Accounts",
})

My problem is how to introduce multiple parent columns into the cascade drop down.

Any idea would be great.

Thanks
Shafie

Coordinator
Dec 20, 2010 at 2:00 PM

Shafie:

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.

M.

Dec 21, 2010 at 12:20 AM

Thanks Marc.

Cheers