Record Producer passing only display value and not sys_id, i think....

[sherard]

Lets see if I can explain this without making it confusing to understand....

I have a scoped app. It has a record producer to a scoped table. All variables are mapped to fields on table/form. One of the mapped variables in the record is a lookup select box defined to reference field. All looks good when using the record producer. I can set all selection variables and they map to fields on the form. EXCEPT for one. It looks like it maps but it doesn't seem like it totally does. However, the Display value is not showing in the field. On the form, I get a 'No Preview Available'. When I double click the reference icon, it does pull up the right record.

Not sure if this is some kind of ACL issue or something, It's like the record producer is only passing the display value and not the sys_id. That is my first thought. But not sure how to fix it.

[Ashutosh Munot1 · Accepted solution]

Hey,

I think it is field type issue. Because on record producer you have look up select box type and in image it is reference type.

Both should be same or else you will have to iterate through look up box via some coding and then take sys_id and set it in to appropriate field.

Thank you,

Ashutosh Munot

Hit Like or Helpful or Correct answer

[sherard]

Yes...that is what I'm finding out. Thanks!

[Ashutosh Munot1]

Welcome

[sherard]

I think I may have found something......I changed my variable from a lookup select box to a Reference variable. To make it a straight reference to reference map. This successfully worked and I see the record accurately in the form reference field.

Is the lookup select box type not something we can use to pass/map to a forms reference field? Do I have to add record producer code to get the sys_id when only using the lookup select box? That's cheesey!!