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