locked
need to use spcascadedropdowns or spfilterdropdown with multiple parents RRS feed

  • Question

  • I have 5 lists.

      • Divisions
        • Title (Division)
      • Subdivisions
        • Title (Subdivision)
        • Division - lookup into Divisions list
      • Tertiary_subdivisions
        • Title (tertiarySubdivision)
        • Division - lookup into Divisions list
        • Subdivision - lookup into subdivisions list
      • Roles_Responsibilities
        • Title (SpecificRoleResponsibility)
        • ShortDescriptionRoleResponsibility
        • Comments
        • Division - lookup into Divisions list
        • Subdivision - lookup into subdivisions list
        • tertiarysubdivision - lookup into Tertiary_subdivisions list
      • Team_roles_responsibilities
      • Title (comments)
      • Division - lookup into Divisions list
      • Subdivision  - lookup into subdivisions list
      • Tertiarysubdivision - lookup into Tertiary_subdivisions list
      • SpecificRoleResponsibility - lookup into Roles_Responsibilities list

    Users will be inserting new rows into team_roles_responsibilities. They will pick Division, subdivision, tertiary_subdivision, SpecificRoleResponsibility. Each dropdown can only have 1 selection. Basically I need to filter the roles_responsibilities list on multiple values. My understanding is that one could use multiple parent columns.

    I'm getting too many rows returned when trying to select from SpecificRoleResponsibility dropdown.

     <script type="text/javascript" language="javascript" src="/Documents/jquery-3_3_1_min.js"> </script>

    <script type="text/javascript" language="javascript" src="/Documents/jquery.SPServices.min.js"></script>

    <script language="javascript" type="text/javascript">

    $(document).ready(function() {

      $().SPServices.SPCascadeDropdowns({

        relationshipList: "subdivisions",

        relationshipListParentColumn: "Division",

        relationshipListChildColumn: "Title",

      parentColumn: "Division",

        childColumn: "Subdivision",

        debug: true

      });

      $().SPServices.SPCascadeDropdowns({

        relationshipList: "tertiary_subdivisions",

        relationshipListParentColumn: "Division",

        relationshipListParentColumn: "Subdivision",

        relationshipListChildColumn: "Title",

        parentColumn: "Division",

        parentColumn: "Subdivision",

        childColumn: "TertiarySubdivision",

        debug: true

      });

      $().SPServices.SPCascadeDropdowns({

        relationshipList: "roles_responsibilities",

        relationshipListParentColumn: "Division",

        relationshipListParentColumn: "Subdivision",

        relationshipListParentColumn: "TertiarySubdivision",

        relationshipListChildColumn: "Title",

        parentColumn: "Division",

        parentColumn: "Subdivision",

        parentColumn: "TertiarySubdivision",

        childColumn: "SpecificRoleResponsibility",

        debug: true

          });

    });

    </script>

    Friday, April 12, 2019 8:29 PM