I know how to create a Value List that displays one field and "enters" the data from a 2nd (related) field. BUT, once selected, the 2nd field is what is displayed. What is the best route to DISPLAY the 1st field selected when selected rather than the 2nd field that is really entered?
I could place a separate field on top of the dropdown menu that displays field 1 selected so it will cover up the actual dropdown display. Is that the best route?