Value Assistance based on Repeating attribute

padma

Hi All,

I have attributes

1.business_unit_descr Repeating

2. bank_cd non repeating

I want to sort ban_cd values based on businees_unit values

1.business_unit   List from register table  ex: 40001,40002

2. bank_cd

Value Assistance

select distinct bank_cd from findoc.DEP_ACCOUNT where bus_unit  in ('40001', '40002')

What should be the query to get values Assistance of bank_cd?

the result should be similar to to the above query

this is the query I used for non -repeating Attribute

select distinct bank_cd  from findoc.DEP_ACCOUNT where bus_unit ='$value(business_unit)'

Any help greatly Appreciated

Thanks

Padma