Display Field Value Dynamically

[Pintu2]

I have a reference field Dept Contacts and another field called Department Cost Center which displays cost center information of the employee like 8900. I want to display Dept Contacts based on Cost Center information.

Like if Department Cost Center is 8900 then Dept Contacts field should only display contacts related to 8900 when user clicks on Dept Contacts field .

I'm stuck at doing this in a couple of ways but not sure I cant achieve this.

Can anyone help me with this?

Appreciate your response!

Thanks

Prashanth

[SanjivMeher]

u_dept_contacts which is a reference field referring to a table. can you tell me the cost center field in that table which is storing the cost center value?

[Pintu2]

Department Cost Center(u_dept_cost_center) is the one which has cost center information on the table.

[SanjivMeher]

Then you reference qualifier should be 

javascript:'u_dept_cost_center='+current.u_dept_cost_center;

[Pintu2]

No Thats not working

[Pintu2 · Accepted solution]

I tried adding a script include in the script with a function for reference qualifier .Then it worked for me.