I have several areas where I have cascading lookups of values. The cascading is not part of the primary question, but may have an impact on the choices of responses, so I mention it up front.
My question is - how do I show the user a value AND the name, but only commit the value into the field?
For instance, I have a list of projects that my users need to select from. I can show them the project number, but that alone is often not enough for them to select the correct item. If I go the opposite way, and display for them the description, then it is often repetitive and they would get multiple choices with nothing to clearly identify the correct one. the combination of both the project and the description in the drop down is the correct solution, but I don't see how to do that.
I had thought about creating a unique view that combines both and using that, but then it screws up the value I need to pass to the cascading lookup.
Please sign in to leave a comment.