Version 7.6.4
I have a form with two list boxes that are chained WORK_CENTER_NO and PROJECT_ID. Box are populated via focexec, because there are joins involved. The values appearing in the two listboxes look correct, however when the selections are made and the report is run, the value of the WORK_CENTER_NO is passed where I would expect the value of the selected PROJECT_ID.
observe the two SELECT statements:

<SELECT id=combobox1 style="Z-INDEX: 5; LEFT: 120px; WIDTH: 130px; POSITION: absolute; TOP: 40px" tabIndex=6 name=WORK_CENTER_NO cacheruntimedata="1" inchainindex="1" chainnumber="0" boundtovariable="1" datasource="crpl1002.fex" datatype="1" sourcetype="typeFex" selectedvalue="WORK_CENTER_NO" datafield="WORK_CENTER_NO" displayfield="WORK_CENTER_NO" operation="NONE" accept="0" addalloption="1" dfformat="A6V" ibic_server="EDASERVE" ibiapp_app="jfoster" dynalldisplayvalue="ALL" textvarname="WORK_CENTER_NO_TEXT" newchainnumber="0"></SELECT>
<SELECT id=combobox2 style="Z-INDEX: 10; LEFT: 360px; WIDTH: 150px; POSITION: absolute; TOP: 40px" tabIndex=11 name=PROJECT_ID cacheruntimedata="1" inchainindex="2" chainnumber="0" boundtovariable="1" datasource="crpl1001.fex" datatype="1" sourcetype="typeFex" selectedvalue="PROJECT_ID" datafield="PROJECT_ID" displayfield="PROJECT_ID" operation="NONE" accept="0" addalloption="1" dfformat="A10V" ibic_server="EDASERVE" ibiapp_app="jfoster" dynalldisplayvalue="ALL" textvarname="PROJECT_ID_TEXT" newchainnumber="0"></SELECT>
  

Observe the variable statements:

<variable field="WORK_CENTER_NO" file="dw_dim_cost_center.mas" desc="Please select Work Center" datatype="1" operation="" default="" name="WORK_CENTER_NO" textvarname="" accept="0" type="unresolved" select="0" min="" max="" controltype="8" create="1"></variable>

<variable field="PROJECT_ID" file="DW_DIM_PROJECTS.mas" desc="Please select a Project" datatype="1" operation="" default="" name="PROJECT_ID" textvarname="" accept="0" type="unresolved" select="0" min="" max="" controltype="8" create="1"></variable>
  

Any suggestions?
Thanks in advance

This message has been edited. Last edited by: Kerry,

Look at utilizing javascript and create arrays based on the choices.

they are chained??
or not...
if they are chained,
change 'cacheruntimedata="1"' to
'cacheruntimedata="0"'

if there are 2 separate fexes making the lists.
make sure the 2nd fex contains a filter
WHERE WORK_CENTER_NO EQ '&WORK_CENTER_NO'

If they are not meant to be chained,
do they each work individually? (nuke the 2nd select and see if you get what you expect for the first)
Have the launch page just execute a simple fex that does nothing more than -TYPE the &vars being passed by the launch page. saves ageda that way.