How can we do this

[Abdul]

i have a reference field in my catalog item which gets the data from cmn_department table.

Whenever a user selects certain department the location field should automatically be populated.  Also this has to be auto populated only when project type is renewal, which is a dropdown field 

How can we do this effieciently.

For eg if the user selects -> 1234 North Atlantic as department then the location field should be populated as Atlantic. 

Would client script work or we have to do with glide ajax?

Thanks 

[Dinesh-SNOW]

you can use onChange client script + getReference callback or GlideAjax for this

what did you start with and where are you stuck?

GlideAjax Example Cheat Sheet (UPDATED)