Hiding the First Field from a Value List

[oakbridge]

For months I've been trying to come up with a method to 'hide' the first field in a value list after it has been selected.

I want to use a value list that draws from a table and stores the key field while always and ONLY displaying the 2nd field. For example, I have a table called reps that has a rep_id field, and a rep_fullname field. On an order table's layout, I have a field for 'rep' which is a value list that draws from the reps table. Everything works fine so far, I've got the value list definition set up so that only the second field is displayed. Except after the user makes their selection and moves to the next field, it is the value from the key field that is displayed. I know that I can display the related field next to it so that rep_id is right beside rep_fullname but screen real estate is tight.

Is there a way to 'hide' what is stored and only display the related field?

[mr_vodka]

See if this helps

Hiding first field technique in drop down menu