Hi I have two fexes fex1 and fex2 with the following code.
I have created a html for fex1 with dropdowns for model and car and button that executes to put the results in iframe1.

Now what I need is, When I run this I would click the button with ALL selection and get results for fex1 in iframe1. Now I drilldown to fex2 results using the column1 drilldown.
Now when I reselect Model and Car and hit button...I want fex2 to be refreshed with the variables selected.

Basically if fex1 results are in iframe and I reselect car and model , I want fex1 to be updated. if current iframe results are fex2 and I reslect , I ant fex2 to be refreshed. Is there a way to do this.???



fex1
TABLE FILE CAR
PRINT
MODEL
CAR
COUNTRY
WHERE MODEL EQ '&MODEL' AND CAR EQ '&CAR';
HEADING
"FEX1"
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=ON,
ORIENTATION=LANDSCAPE,
$
TYPE=REPORT,
GRID=OFF,
FONT='ARIAL',
SIZE=9,
COLOR=RGB(51 51 51),
RIGHTGAP=0.000000,
LEFTGAP=0.000000,
$
TYPE=DATA,
COLUMN=N1,
FOCEXEC=app/fex2( \
MODEL=N1 \
CAR=N2 \
),
$
ENDSTYLE
END

fex2
TABLE FILE CAR
PRINT
MODEL
CAR
COUNTRY
WHERE MODEL EQ '&MODEL' AND CAR EQ '&CAR';
HEADING
"FEX2"
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=ON,
ORIENTATION=LANDSCAPE,
$
TYPE=REPORT,
GRID=OFF,
FONT='ARIAL',
SIZE=9,
COLOR=RGB(51 51 51),
RIGHTGAP=0.000000,
LEFTGAP=0.000000,
$
ENDSTYLE
END
END

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

Perhaps this recent post will help you.
http://forums.informationbuild...71057331/m/381103413

Unfortunately , it does not help my issue here....

getit without seeing the HTML that you are using it's quite difficult to see where you need to make
the needed changes.

However basically you need to change the drilldown type from focexec to javascript
and use some javascript which will flip the value of the drilldown
and submit the request.