Do you mean typing value from 2nd field then complete(?) 1st field value?
Thanks for the response, sorry I'm getting late back to this, I didn't think anyone had replied.
The desire is to click into the field (currently by clicking an arrow first) begin entering the first characters of the second (right side field in the value list maker), not see the left side field values, self edit the right side as you type (like expected) but then set the field with the left side field value (in this case the Record Key).
So the user thinks he is choosing from a "drawing" list, but selects the primary key. The Primary Key will then appear in the field, the drawing number will appear in it's own field.
This is used in a portal, if it matters.
In the case, second field don't have duplicated value. So, use one more value list, get values from second field. You can use it for auto complete.
Then auto enter using completed value to get target primary key value with lookup() or ExecuteSQL() function.
Something to think about, thanks.