How to use Catalog Builder to lookup data in the same table.

[cherylkirkc]

I'd like to do this with Catalog Builder. 
I'm working on a Service Catalog Item. On the form, I have a variable that accesses the cost center table. 

In my cost center table I have:

• Fund 
• Department which is a child of Fund 
• Unit which is a child of Department / grandchild of Fund

So say I have Fund = 100

Department = IT with parent 100

Unit = Service Desk which has a parent of IT

On the catalog item I want to select Fund =100 and then see IT showing in the Department variable. 

I know I can do this without scripting, but i must be selecting the wrong filter. Any help is appreciated. 

[PeriyasamyP]

You can archive this with advance reference qualifier on department variable.

For ex,
javascript&colon; "parent="+current.variables.<fund>