Reference Qualifier Controlled by a specific field value

[tech_tc]

How can I apply a reference qualifier   to a department reference list. I want to control what the current user can see by a specific value in another field on the department table. I'm using Calgary so can't benefit from Eureka improvements for creating ref qualifiers.

For e.g. of what I'm trying to achieve.

All departments have a field called 'SSGROUP' (u_ssgroup on the cmn_department table). If we add the value 'ITDept' to this field, the user filling out a 'New Starter' form, should only see departments that have the 'ITDept' value in place. Query like u_ssgroupSTARTSWITHITDEPT

Access to the relevant departments is done by groups. e.g. the ITFILTER group on the sys_user_group table.

Can this be done as an Client Script on its own, or a client script calling a script include? I really could do with some help developing the scripts.

[tech_tc]

Thanks Kalaiarasan

I did use a ref qual in the end.