Hello,

Maybe someone here can help me with this.

I have 2 queries, and I would like to combine the results of those 2, and
add the result to a picklist on the a form.

I have tried the following (and variations of the following), but it
isn't quite the correct result I am getting. Any answers appreciated. I
will be forever in your debt, should you have the perfect idea for a
solution.

var combinedRoles = new Array();

var delegatorRoles = IDVault.globalQuery(null,
"QRoleKompetenceDelegateRightsRoles", {name:"*"});
var delegateableRoles = IDVault.globalQuery(null,
"QRoleKompetenceDelegateable", {name:"*"});

if (delegateableRoles.length > 0 ) {
var i = 0;
while ( i < delegateableRoles.length ) {
combinedRoles.push(delegateableRoles[i][0]);
i++;
}
}
if (delegatorRoles.length > 0 ) {
var i = 0;
while ( i < delegatorRoles.length ) {
combinedRoles.push(delegatorRoles[i][0]);
i++;
}
}

field.setValues(combinedRoles);

-Nicolai