Goodmorning everyone
instead of inserting the automatic query into a ‘select field’ it is possible to load the data obtained from a query into the pop pu of the select
I tried with a javascript procedure but it doesn’t work
var select = document.F1.foods [0];
select.options.length = 0; // clear out existing items
for (var i = 0; i <myarray.array.length; i ++) {
var r = myarray [i];
select.options.add (new Option (r.text, i));
}
where you feed is the select field and myarray is the ary obtained from a query
I tried to load the query inside the select but the quesry part appne I add a record and this blocks everything
The query contains an “IN” that it does not execute
Thank you
Mimmo