Problem: When using an entity picker on an InfoPath2010 form, the textbox populates with the ID of the selected value. Instead, you want to display a user-friendly value. How do you do this?
For this Q&A we’ll be using the second value from the picker in Figure 1:
When the second value is selected the page is populated with the ID, which you can see in Figure 2:
Solution: To display more user-friendly text to the user, in InfoPath Designer 2010, specify the Finder Name and Display Name properties in the External Item Picker properties for the entity picker, which Figure 3:
After republishing the form, the page will display the user-friendly text, which you can see in Figure 4.
Read more SharePoint Q & A's :
Sharepoint Q&A: How Can I Create an External List When SharePoint Throws an Unspecfied ASP.NET Error?
Sharepoint Q&A: How Can I Create an Action for an External Content Type in SharePoint?
Sharepoint Q&A: How to Make a Type String Type Descriptor a Required Field in the BDC Explorer
Sharepoint Q&A: Data Source Conflict