Hi All,

Tried to find this issue in other post but I have not been able to get anything. I am trying to use SPservices jquery script lookup valuer across 2 columns, I was hoping someone would be able to assist:

I have a sharepoint list named journal spservices tutorial and i got the query against the Title working no problems. However when it is querying against multiple columns Title and Product. I get empty results:

NWF$(document).ready(function() {

  //The source data for the autocomplete is the Journals list  

  //Store the journal titles in a array variable  

  var externalParties = t];

  NWF$().SPServices({

    operation: "GetListItems",

    async: false,

    listName: "Journals",

    CAMLViewFields: "<ViewFields><FieldRef Name='Title' /><FieldRef Name='Product' /></ViewFields>", //the name needs to be changed accordingly   

    completefunc: function(xData, Status) {

      NWF$(xData.responseXML).SPFilterNode("z:row").each(function() {

        externalParties.push(sNWF$(this).attr("ows_Title"),NWF$(this).attr("ows_Product")]);

      });

    }

  });

  //journalinput is added on the control in the NF  

  NWF$("#" + journalinput).autocomplete({

    source: externalParties

  });

});