🚀 go-pugleaf

Hi -

I need to populate a JdbComboBox with a list of choices from column in
my database.  I want these choices to be strings, and I want the number
that is stored in the field corresponding to the selection to be an
integer that corresponds to the choice.  For example, with the following
"City Table":

Name column        Number column
New York            1
Washington           2
Tokyo                   3
Paris                     4

I want the four strings to show up in a ComboBox, and when I select one
of the values, I want the corresponding number to be stored in the field
that is tied to the ComboBox.  Is this what a pick list is for?  I've
tried to get a pick list to do this, and I guess that I must be doing
something wrong.  Can anyone explain what I need to do or point me to a
resource that will help me accomplish this?  Thanks for your help.

--
J. Brian Hughes

Software Engineer
R&D Switch Group
NACT Telecommunications, Inc.