Hello expert,

Thanks lockwelle, yes, I am sure there is user for the selected values.

Example data below:

userID      department   section    unit     
-----------  ----------------   -------      ---------
001                   IT            A              2
002                   IT            A              3     
003                   IT            A              NULL
004                   IT            B              4 

Dynamic parameters:
level 1 - Department
level 2 - Section
level 3 - Unit
last level - User

When IT Department selected , section A and B will list in section's parameter box. If section A has been selected,  unit 2 and 3 will display in unit's parameter box. Let say I select unit 2 and 3, user 001 and 002 will list in user parameter column.

How to display user if I select department or section itself? Let say I select IT Department , i want to list all of 4 users. I don't want to drill down until to unit then from there to get the user. The reason is because some of the users do not have unit ID. Therefore I still need them to display in the paramater screen for selection.  Hope you understand my concerns.

Thanks much!

thank you so much! you saved my life. Your solution is workable :) 

Edited by oks911 - 26 Jul 2010 at 4:48pm