reference field vs lookup select box

[si21]

Hi experts,

we have variable on record producer which has to show a specific field (u_can) which is a string field from user table.

This can be achieved by look up select box but it is causing performance issue by loading very slowly.

So I have tried using reference field but unable to display and select the custom field (u_can).

How can we achieve this? How can we show and display the custom field on variable using reference?

TIA

[Ankur Bawiskar]

@si21 

then do this

1) have a reference variable and onChange of that populate the custom field value i.e. u_can in another single line text variable

If my response helped please mark it correct and close the thread so that it benefits future readers.

[si21]

Hi Ankur, thanks for reply. In the image below, this is a lookup select box table:user and field: u_can. But this loads almost after 90 seconds.

I want to display as below using reference field. How can I do this.