How do you change a drop down control from Multi-select to Single-select in Page Designer.

Currently when PD creates the filter bar dropdowns are defaulting to Multi-select and I need it to do single select.

This message has been edited. Last edited by: FP Mod Chuck,

quote:

FHCole04

1. If you are trying to create custom dropdown filter then try below code:

-SET &TEST = &TEST.('TEST1','TEST2','TEST3','TEST4','TEST5','TEST6','TEST7',).Test Dropdown:.QUOTEDSTRING;

2. If you are creating filter from Synonym values:

-SET &CNTRY= &COUNTRY.(FIND CAR1.ORIGIN.COUNTRY IN CAR1|FORMAT=A10).Country:.QUOTEDSTRING;

3. If you want to directly have filter on a table file request try like this :

TABLE FILE CAR1
BY CAR1.ORIGIN.COUNTRY
BY CAR1.COMP.CAR
BY CAR1.CARREC.MODEL
WHERE CAR1.ORIGIN.COUNTRY EQ &COUNTRY.(FIND CAR1.ORIGIN.COUNTRY IN CAR1|FORMAT=A10).Country:.QUOTEDSTRING;
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLEMBEDIMG ON
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/warm.sty,
$
ENDSTYLE
END


Let me know if this works or you need something else.

Thanks for the reply Rajesh. This works great.

I had to remove the OR from my find and add the QuotedString to the end.

Happy to help....