How do i properly use a Lookup select box to populate the value of a field on the caller's user record in a record producer?

[RBlor]

I am working on a record producer and was trying to use the lookup select box to autopopulate the caller's emp# field on the form. for some reason i only get the sysid show up. the field on the user table is a string field. . Any tips on getting this working

[Pradeep Sharma]

You are very welcome @RBlor 

[sonu9]

Hi @Pradeep Sharma 

I am having the same issue and I am only using one column name in label but still it is showing sys_id. 

FYI - field type is referenced