Adding a Drop Down Box - LSF9-iSeries-RPGLE

You will need to use design studio to customize the RQ10 form.

Actually you don't. We have 6 other programs we modified screens and print files by hand. I'm just not sure of the steps for a drop down box.

I don't touch any lawson delivered files cause i don't want to claim ownership of the files in the event that I require lawson support. Thus, I use design studio for customized form.

You really have three parts to this customization:

1. Adding a drop-down
2. Populating the drop-down
3. Relating the customer with the requisition

Items 1 & 2 are fairly common tasks that can be accomplished with Design Studio.  It's item 3 that is the tough one.  Likely, you will incur future technical debt (read: upgrade pain) if you modify the base RQRQH/REQHEADER table.  You should consider storing it in a user field or what I call a "shadow table".

Of course, if you're using OE/BL, you might be able to relate back from the requisition to the OE tables via the WHDEMAND records.

Hi John,
I had a quick question on the dropdown list via Design Studio...I'm using another example provided in the forum and it works great with one small problem. On the GM12 screen I'm populating a dropdown list after the user tabs out of the employee field. Seems to work great the first time, but then if the user selects another employee it leaves the values from the last employee and adds the current employees values to the list.

Here is my original code:
var DMEstring2 = "/cgi-lawson/dme.exe?PROD=" + vProd + "&FILE=GMLABDIST&FIELD=EFFECT-DATE;&INDEX=GMLSET3&KEY=1=" + vEmployee +
"====&XCOLS=TRUE&XKEYS=TRUE&XRELS=TRUE&XCOUNT=TRUE&XIDA=TRUE&XNEXT=TRUE&OUT=XML";
var DMEinfo2 = top.httpRequest(DMEstring2);

if (DMEinfo2.status)
{
alert(DMEinfo2.status);
return;
}
var vOBJDMEXML = new top.DataStorage(DMEinfo2);
var vRecords2 = vOBJDMEXML.document.getElementsByTagName("RECORD");
//alert (vRecords.length);
if (vRecords2.length ==0)
{
//alert("No Records Exist");
return true;
}
var miscList = document.getElementById("VALUES_l76");


var tVals;
for (var i=0;i <= vRecords2.length; i++)
{
var vCols=vRecords2.getElementsByTagName("COL");
var vEffDate = vCols[0].firstChild.data;
var vEffDate2 = pfDate(vEffDate, 'MM/DD/YYYY');
var vEffDate3 = getDateAGS(vEffDate2, 'YYYYMMDD');
tVals = document.createElement("span");
tVals.setAttribute("text", vEffDate3);
tVals.setAttribute("tran", vEffDate3);
tVals.setAttribute("disp", vEffDate3);
miscList.appendChild(tVals);

}

I tried adding a loop to remove the values before adding new values but it doesn't seem to be working...here is what I tried:
for( var i = 0; i < miscList.childNodes.length; i++ )
{
miscList.removeChild(miscList.childNodes)
}

Any ideas on how to get rid of the values from the last employee?

thanks