Madhu Ravipati

• Sep 13th, 2006

 

create two valuesets and first one is independent value set and define values .and then create dependent value set .And in the dependent value set form you can find edit information button.click on that and then another window open there in the independent value set block give the independent value set name.Thanks,Madhu Ravipati

Brajesh Singh Bhadoriya

• Dec 21st, 2006

 

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

 

Guest

• Jan 4th, 2007

 

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