Avatar

Level 2

wrt

Are the values that populate the DDlists in different tables or the same one? - Yes different ones

If they are in different tables then I think you  will need a different data connection per table. I agree.

If they are the same then you shodul be able to define the SQL statement that you want to run in the current code.

I suggest that you use the exit event of the DDList and not the change event. - Will try

At the moment, using a button to initiate the data source for the #2 dDown with the following code

var myClientID2 = SelectedClientID.rawValue;

var nIndex = 0;
while(xfa.sourceSet.nodes.item(nIndex).name != "Years")
{
nIndex++;
}

var oDB2 = xfa.sourceSet.nodes.item(nIndex).clone(1); // the node pertaining to the data connection specified


oDB2.nodes.item(1).query.setAttribute("text", "commandType");
oDB2.nodes.item(1).query.select.nodes.item(0).value = "Select * from Years where ClientID = '" + myClientID2 + "'";

//now connect to DB and get a record

oDB2.open();

But nothing works (totally lost)