I have a lookup field that contains the following:
Table: LookupTable
Link Field: DisplayValue
Display Field: DisplayValue
Order By: LastName
Edit box with AJAX popup, allow free input, allow multiple selection
LookupTable:
Display Value = "Jim Jones <jim.jones@example.com>"
LastName Value = "Jones"
Why is it when I start to type "Jim Jones" that the edit box only displays "Jim Jones" vs "Jim Jones <jim.jones@example.com>". Once I select the entry, the edit box displays "Jim Jones <jim.jones@example.com>" like it should. I need to see the complete value when searching as there may be a "Jim Jones <jim.jones@example.com>" and a "Jim Jones <jim.jones@anotherdomain.com>". There is no way to tell which record is being selected if I only see the "Jim Jones" part.
Why is this happening and how do I fix it?
This is how the dropdown looks:
This is how the result looks:
