It there a way to do database lookup showing results in the form of a table view and allow the user to choose from a list of extended values. For example:
I want to lookup all employees with the Last name: Smith
I actually Want:
Smith, Joe , 12345
Currently I have to setup a lookup rule for lastname: and Populate the firstname field. and Employee number
When Multiple smiths are found I have to choose from the resulting Firstnames in that field.
If we had a Lookup view that allowed us to search by lastname but show a list of results with the expanded info showing all smiths along with firstname and Employee number. Then we could allow the user to make a much more intuitive choice as to which Smith, directly from the first DB lookup. Please let me know if this can be done. I have not figured out how as yet.
There are so many uses for this type of db Lookup experience.
I feel that many customers would benefit from this functionality out of the box.
Many other systems have this type of functionality and it makes life easy for the user.