The Zurich release has arrived! Interested in new features and functionalities? Click here for more

Reference qualifier with cilent script

AnnamalaiS
Tera Contributor

I have cost center field (select lookup with reference to cost center table) and project category field (selectbox with manually entered values).

 

Cost center based on project category.

 

Example: scent (project category) has 3 cost center. It should only visible instead of showing the whole list.

 

I need reference qualifier with client script for this.

 

26 REPLIES 26

Hi,
I created a custom table (u_proj_category_costcenter_map) with two string columns- one for project category (u_project_category) and another for cost center (u_cost_center_name)

There is a relationship between the project category and cost center in the table u_proj_category_costcenter_map.

Could you please show how the cost center is stored in this table? A screenshot would really help to clarify.