create one value set. This value set will get first parameter. while creating second Value set use :$FLEX$.<first value set name> in the condition. for example I m creating two value sets i.e. department number and employee in department. if in first value set i m getting value of department number i will create a independent value set which will fetch all the department numbers. In sencond value set i want only those employees who are in the department selected then create another value set for employee which will be independent and in the where/order by block write condition like:

where employee.department_number :$FLEX$.<first value set name> and <other conditions>

this will create the second value set having values depending upon first one.

thanks

Brajesh

hi

we an do ways

1)creating independent valueset and based on this we can create dependent valueset .1st can select independent then only we can chosse dependent value set

2) By using tablr valueset ... 1st table1 is create an d table2 in table 2 u can write in where clause ..$flex$.priveouse value set