Skip to content
+1-888-319-3663

COMMUNITY FORUM

Lookup on Form showing ID but would like it to show Value

Pieter du Toit asked 5 years ago
Is it possible to show the value for a lookup instead of the ID?  I have a Extender Form (Form1) that I added a lookup to another Extender Form (Form2).  From2 uses automatic ID numbering and has only one additional field based on a List.  When you do a lookup in Form1 to Form2, it displays the ID in Form1 which really does not mean anything.  It should show the value related to that ID.  For instance, if the ID on Form2 is 1 and the value from the list is Paper, then Paper should be displayed on Form1, not the ID of 1 since that means noting when you are using Form 1. 
Answers
Patrick Roth Staff answered 5 years ago
“Is it possible to show the value for a lookup instead of the ID? “
No.
The Lookup is based on the ID because it cannot be changed.  You wouldn’t want to put in another value (that is copied to another Form2 data record) and then be able to change it in Form1.
“For instance, if the ID on Form2 is 1 and the value from the list is Paper, then Paper should be displayed on Form1”
In Form2, you select the ID for Extender Form1 record.  But in Form1 you see both the ID and the Description.
Not sure if you meant “Paper” to be the Form1 record description or a list or string field on Form 1.  But you never select the individual data fields- only the Form ID and see the Form record description.
patrick

If you would like to submit an answer or comment, please sign in to the eOne portal.