Reference field showing sys_id

[ceraulo]

Hi!

I have a custom form called u_ctable1 which contains 3 fields: field_1, field_2, field_3. All fields are string fields. field_3 is a function string field that concatenates field_1 and field_2.

I have another custom form called u_ctable2 that has a reference field , referencing u_ctable1.  It is correctly displaying the field_1 value. What I want to do is to display 'field_3'.

How to do this?

Thanks!

[Dubz]

change the display value of that table to field 3 and it should be displayed in any field referencing it

[ceraulo]

I've tried this earlier but I'm getting this error when I open a record from ctable2.

[Dubz]

Ah ok i see you said it's a function string field, i've not worked with function fields much, i guess they calculate the value whenever a form loads so you can't display them.

Is there any reason you're using a function field rather than just populating the field with a before update business rule? if it needs to be done live on the form you could do it with an onChange client script. I don't really see the necessity for a function field here...

[asifnoor]

Hi,

Make field3 as display value of u_ctable1. Then in ctable2, you will see field 3 value instead of field 1.