Help with updating a Dropdown list based on another Dropdown list

Dec 19, 2013 at 3:16 PM
I have a List with Title and Status. I have the main list that users enter the data and a field called Reason that references the List with the title and status. I have another Field called Urgent/Routine that I want to set based on the status of the Reason that they chose. The reason it is a dropdown is because I want the user to be able to change it. I have the following code but it doesnt set the dropdown value. Can someone help me?

$(document).ready(function() {

$("select[title='Reason']").change(function () {

var ReasonID = $("select[title='Reason']").val();

operation: "GetListItems",
async: false,
listName: "{B87006A8-B8BA-40D1-A569-4275CC023A63}",
CAMLViewFields: "<ViewFields><FieldRef Name='Title' /><FieldRef Name='Status' /></ViewFields>",

CAMLQuery: "<Query><Where><Eq><FieldRef Name='ID' /><Value Type='Counter'>" + ReasonID + "</Value></Eq></Where></Query>",

completefunc: function (xData, Status) {
  $(xData.responseXML).SPFilterNode("z:row").each(function() {

    var Status = $(this).attr("ows_Status");



Dec 19, 2013 at 5:46 PM
Nevermind, I solved it.