Department Table.

[Tehreeem]

Hello Team,

Please help me by suggesting for below:

I am using department table as a reference table in my custom table for one of its field.

So during selection look up value is coming as  department ID but I want it to populate Dept name, As display value is true for dept id,and is already useful for other custom table to populate the dept ID in their forms.

Is there any way to set lookup value for department name for only my custom table?

Thank you!

Looking forward for valuable suggestions:)

[Jaspal Singh]

Unfortunately, No. You can use ref_ac_column search to do an additional search by Name but as you right it will poupulate Depart ID as it has Display to True

Alternatively, you can creaet a new field that will store calculate value for Depart Name & Department ID & then set Display as True for this table. An example of this is Name field on the user table that stores calculated value for First Name & Last Name