This project has moved and is read-only. For the latest updates, please go here.

Cascading Drop down will not work with Related Info

Nov 11, 2010 at 3:12 PM

Hi, as requested here is a new thread for my issue.  By the way, thanks for all the time and effort - these are amazing resources for those of us who (like me) who are not programmers but are expected to deliver solutions with programming.  lol 

I am not able to get these to functions to work together either.  I am able to use them seperately.  When they are on the same page (the same CEWP) the functionality works until the user hits the OK button. 


<script language="javascript" type="text/javascript" src="**removed**/jQuery%20Core/jquery-1.4.2.min.js"></script>
<script language="javascript" type="text/javascript" src="**removed**/SPServices/jquery.SPServices-0.5.7.min.js"></script>
<script language="javascript" type="text/javascript">
 $(document).ready(function() {
   relationshipWebURL: "**removed**",
   relationshipList: "**removed**",
   relationshipListParentColumn: "Business_x0020_Unit",
   relationshipListChildColumn: "Title",
   parentColumn: "Business Unit",
   childColumn: "Department",
   debug: true
   columnName: "Job Level",
   //relatedWebURL: "",
   relatedList: "**removed**",
   relatedListColumn: "Title",
   relatedColumns: ["Title", "FLSA_x0020_Exemption_x0020_Statu", "Pay_x0020_Grade", "Min_x0020_Req_x0020_Experience", "Min_x0020_Req_x0020_Education"],
   displayFormat: "table",
   headerCSSClass: "ms-vh2",
   rowCSSClass: "ms-vb2",
   numChars: 0,
   matchType: "Eq",
   //CAMLQuery: "",
   completefunc: null,
     debug: true

Upon hitting the OK button the user gets the standard error message: 

 "Server Error in '/' Application."

Nov 12, 2010 at 3:07 AM

Glad to be of assitance. ;+)

As I said before, I know that these two can work together and I've tested them pretty extensively so that I can say that.

There's probably more to the error message that just "Server Error in '/' Application." Can you post the rest of it?


p.s. Here's an example I have working with both calls. As you can see, I actually have three "cascades" going on with SPDisplayReleated info on the Region.

    webURL: "",
    relationshipList: "Regions",
    relationshipListParentColumn: "Country",
    relationshipListChildColumn: "Title",
    relationshipListSortColumn: "Title",
    parentColumn: "Country",
    childColumn: "Region",
     promptText: "Choose Region...",  // [Optional] Text to use as prompt. If included, {0} will be replaced with the value of childColumn
    debug: true
    relationshipList: "States",
    relationshipListParentColumn: "Region_x0020_Name",
    relationshipListChildColumn: "Title",
    parentColumn: "Region",
    childColumn: "The State",
    debug: true
    relationshipList: "Cities",
    relationshipListParentColumn: "State",
    relationshipListChildColumn: "Title",
    parentColumn: "The State",
    childColumn: "City",
    debug: true
    columnName: "Region",               // The display name of the column in the form
    relatedWebURL: "/Intranet/JQueryLib",           // [Optional] The name of the Web (site) which contains the related list
    relatedList: "Regions",               // The name of the related list
    relatedListColumn: "Title",              // The internal name of the column in the related list
    relatedColumns: ["ID", "Country", "Title", "Total_x0020_Sales"],  // An array of related columns to display
    displayFormat: "table",               // The format to use in displaying the related information.  Possible values are: "table" (not yet implemented).
    completefunc: addDollarSigns,
    //completefunc: doSomething,
    debug: true