3-level cascadedropdowns with duplicate values in teh second level

Sep 12 at 2:03 PM
$().SPServices.SPCascadeDropdowns({
relationshipList: "Provider Services",
relationshipListParentColumn: "Provider",
relationshipListChildColumn: "Service_x0020_Name",
relationshipListSortColumn: "Service_x0020_Name",
parentColumn: "Provider",
childColumn: "Service",
simpleChild: true,
debug: false
});

$().SPServices.SPCascadeDropdowns({
relationshipList: "Service Operations",
relationshipListParentColumn: "Service1",
relationshipListChildColumn: "Operation_x0020_Name",
relationshipListSortColumn: "Operation_x0020_Name",
parentColumn: "Service",
childColumn: "Operation",
simpleChild: true,
debug: false
});
The above code works for me if the column values are unique. If service column has duplicates, when I select provider=xxx, service=duplicate then operation will lookup ahh the operations under duplicate service, I want to filter it with two parent elements provider=xxx and service=duplicate.

provider service operation
a rest op1
b rest op2
c go op3
d go op4
When provider=c,service =go, then operation is both op3&op4, but I need only op3 depending on c&go.