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]

You can add a reference qualifier on Dept Contacts table for ex.

javascript: 'cost_center='+current.u_dept_cost_center

assuming cost_center us the field name of cost center in Dept Contacts and u_dept_cost_center is the field name of Department Cost Center 

[Pintu2]

I tried adding javascript:'u_dept_contacts='+current.u_dept_cost_center;

but it didnt work .still it is showing the all the records.

[SanjivMeher]

What is the field name of Department Cost Center ?

And what is the field name of the cost center field in Dept Contacts table?

[Pintu2]

Department Cost Center - u_dept_cost_center

Dept Contacts is a field - u_dept_contacts-reference field

these are 2 individual fields on u_employee table .So on form view when a employee ABC  has cost 8900 and when user clicks/selects on Dept.Contacts field it should only show dept contacts related to 8900.