how to show name instead of sys_ID on sys_choice table

[Teresa8]

On the Incident form, Service offering is a Reference field (referencing the service_offering table) and the Issue type field is a custom choice field, dependent on what is entered in the Service offering field. 

When I view the sys_choice table for the choices set up for Issue Type, in the Dependent value field I expect to see the name of the service offering, in this case "Dexis", but instead I see the sys_id for the service offering. Is that because of the field types on the Incident form? I can see the name/label in the Dependent value field for other elements on the sys_choice table. It's just the u_issue type element that is showing the sys_id for the Dependent value. What/where do I need to change to make the Dependent value show the name field instead of sys_id?

[abrouf]

Open referenced table

Open form

Right-click on the field label (which field you want to see in the reference field)

Set display to true.

For further info, follow this thread-https://www.servicenow.com/community/developer-forum/field-is-showing-sys-id-instead-of-value/m-p/2442435#M9...

[Uncle Rob]

Exactly right.  when you're dependent on a reference you need the 100% certainty unique value, and that's the sys_id.  When you're dependent on a choice field, you need that field's value (not label).

Don't think there's any way around this.