Has anyone done the following -- we are using WF 5.3 -- populate a drop down list depending on
the value of another drop down list. For example, using the CAR table, I could select one country from a drop down list and depending on which country I selected another drop down list would display the models associated to that country. I would like all this done within one window.
Thanks

There is a method if you know the list which has to be populated in the second for any selection of the first.
Based on the selection on the first list populate the second using javascript.

function LoadList(text) {
var optionName = new Option(text, text, false, false)
var length = whatTo.length;
whatTo.options[length] = optionName;
}

It's called chaining. You can do this in Resource Layout. Select the two dropdown boxes and chain them together using the dynamic chain button at the bottom of the screen ( a couple of chain links with a PLUS sign).

That'll do it.

Ken

the only drawback to using js arrays is that you can't select a variable from the 2nd list..first.
you're imposing an order.
Cyril..is this correct? or is there a way around that?
tia.

I have done something similar, where you can select from the boxes in any order, and have the others re-written. I have trimmed out all but 3 drop-down boxes from this example. It uses focus code to re-write the drop-down lists because my js ability is very poor. You can only pick "ALL" or one option from each box and have it work. Also I didn't know how to code the "Reset" button. In the real code the drop-down lists are not generated from the "CAR" or any other permanent file, but a hold files that contain all valid combinations which are only created 1x per job, to speed up processing (a lot)

-* Only run first portion if this is the first time or reset.
-DEFAULT &XTIME=0;
-IF &XTIME NE 0 GOTO SKIPFIRST;
-*Create the hold files for the drop-down possibilities here. (excluded from this code)
-DEFAULT &LOB='ALL'
-DEFAULT &COUNTRY='ALL'
-DEFAULT &STATE='ALL'
-SKIPFIRST
-SET &XTIME=&XTIME + 1;
-* Set up files for drop-down boxes
FILEDEF LOBLIST   DISK &TEMPPATH|loblist.txt
FILEDEF CNTYLIST  DISK &TEMPPATH|cntylist.txt
FILEDEF STLIST    DISK &TEMPPATH|stlist.txt
-RUN
-*Write the "ALL" option for all drop-down boxes, or one selected value if already selected
-WRITE LOBLIST  &LOB 
-WRITE CNTYLIST  &COUNTRY 
-WRITE STLIST  &STATE 
FILEDEF LOBLIST   DISK &TEMPPATH|loblist.txt (APPEND
FILEDEF CNTYLIST  DISK &TEMPPATH|cntylist.txt (APPEND
FILEDEF STLIST    DISK &TEMPPATH|stlist.txt (APPEND
-RUN

DEFINE FILE CAR
LOBOPTION/A120 = '' | MODEL |'';
CNTYOPTION/A120='' | COUNTRY |'';
STOPTION/A120='' | STATE |'';
-* Get values for Location drop-down boxes if not already selected
-IF &LOB NE 'ALL' GOTO SKIPA1;
TABLE FILE CAR
ON TABLE SET HOLDLIST PRINTONLY
SUM LOBOPTION
BY LINE_OF_BUS_CD NOPRINT
-IF &COUNTRY EQ 'ALL' GOTO SKIPB1;
WHERE COUNTRY_DESC EQ '&COUNTRY'
-SKIPB1
-IF &STATE EQ 'ALL' GOTO SKIPC1;
WHERE STATE EQ '&STATE'
-SKIPC1
WHERE LINE_OF_BUS_DESC NE ''
ON TABLE HOLD AS LOBLIST FORMAT ALPHA
END
-SKIPA1

-IF &COUNTRY NE 'ALL' GOTO SKIPB2;
TABLE FILE LOCATION
ON TABLE SET HOLDLIST PRINTONLY
SUM CNTYOPTION
BY COUNTRY_DESC NOPRINT
-IF &LOB EQ 'ALL' GOTO SKIPA2;
WHERE LINE_OF_BUS_DESC EQ '&LOB'
-SKIPA2
-IF &STATE EQ 'ALL' GOTO SKIPC2;
WHERE STATE EQ '&STATE'
-SKIPC2
WHERE COUNTRY_DESC NE ''
ON TABLE HOLD AS CNTYLIST FORMAT ALPHA
END
-SKIPB2

-IF &STATE NE 'ALL' GOTO SKIPC3;
TABLE FILE LOCATION
ON TABLE SET HOLDLIST PRINTONLY
SUM STOPTION
BY STATE NOPRINT
-IF &LOB EQ 'ALL' GOTO SKIPA3;
WHERE LINE_OF_BUS_DESC EQ '&LOB'
-SKIPA3
-IF &COUNTRY EQ 'ALL' GOTO SKIPB3;
WHERE COUNTRY_DESC EQ '&COUNTRY'
-SKIPB3
WHERE STATE NE ''
ON TABLE HOLD AS STLIST FORMAT ALPHA
END
-SKIPC3

-HTMLFORM BEGIN


























	

	
Eligibility

	Pick selections and then click Submit
	
	

	

	
	
	
Line of Business:

	
!IBI.FIL.LOBLIST;
	
	
	

	
Country:

	
!IBI.FIL.CNTYLIST;
	
	
	

	
State:

	
!IBI.FIL.STLIST;
	
	
	

	

	
	
	
	
	
	

	

	
Output Type:

	PDF 

	Excel 

	HTML 

    
	
	

	
	
	

	To reset, 
 use the back button
 on your browser.
	



-HTMLFORM END
 
 

This message has been edited. Last edited by: <Maryellen>,

applause, Nicola. that is very nice work.
nice use of the onchange command.
that's more usable than the javascriptarray method, i think, less restrictive to the user.
javascript array would be easier to hardcode, but harder to write fex to create in batch as a server-side include.
thanks very much for sharing. I hope you've considered submitting as a speaker at summit next year.

I'm pretty sure someone has posted that use of onChange command here before. Like I said, my js coding is not that good, I'd have to have gotten it from somewhere.