how to display values of one table from another table using client script

[Pallavi16]

i have a request where i have one field called "requested By" from "sys_user" table which is of reference type variable in catalog form.

i  have other variables where it should display the values from "computer table" based on name from above table.

Can  anyone help me on this

[Ankur Bawiskar]

Hi,

you can use GlideAjax to get the display value as client side doesn't allow multiple dot walking

check this link which has solution on how to return multiple values from GlideAjax and set those; enhance for your case

Get User Details based on the Logged in user/ User selected in Client Script

Regards
Ankur

[Prasad Pagar]

Hi,

Sorry I didnt realise you were using client script.

I will definitely recommend approach suggested by Ankur. That is best practice. Also to get value for second you need to double dotwalking which is not supported in getRef callback function so you left with choice of GlideAjax or Business rule.

Thank you
Prasad