How would I create a dropdown control in SharePoint that has multiple columns?
Similar to a multi-column combo box in Access where the control is bound to the
first column only.

For example, I have a list that has a Code field and a Description field.

What I would like to see is:

123 | Orange
234 | Blue
345 | Green

And, I want to use this list as a drop down for another list and the value would
only hold the Code after a selection is made.

This does not sound like you can do it with out custom coding but if anyone
knows any other way to do it using Sharepoint designer or some other way, I
would liek to hear.