drop down to select all values

[alexpanjhc]

Hi  

my client asked me to use a drop down list so that she is able to pick all values.

for example:

there is a category field with the values 'A', 'B', 'C' and 'D'

now she wanted to add another value called 'All' that displayed in the drop down so when she picked that value it will show all.

so in the drop down it will show  'A', 'B', 'C' ,'D' and 'All'

I could think of island table to create an inline table but not sure what to do with it  so I am asking your wisdom to help.

thanks!

[MayilVahanan]

Hi

Try like below

Temp:
Load * Inline
[
Dept
A
B
C
D
];

Final:
Load Dept as DisplayDept, Dept Resident Temp;
Load 'All' as DisplayDept, Dept Resident Temp;

DROP Table Temp;

use DisplayDept in dropdown list.