list box shows ID field instead of value list text

Hppay New Year.

I have a form that is perfect except I have a list box to a related
table/value list.
In this form the list box shows the value list properly but when the user
selects the option it returns the serialID not the value which isn't very
helpful to the user.

I don't want to recreate the form to add the related value list table. I
just want the value typeA or typeB in the list instead of the serial number 1
or 2 so the user knows what type of data entry it is. Can you fix it with a
calculated field and do I add a 2nd field to the form?
--
Janis

Filemaker,
The following setup will allow the user to select a SerialID (1, 2, etc) by SerialText
("TypeA", "TypeB", etc), but store the SerialID in the bound listbox.

Given a listbox named lstSerialID (same for combos too) with 2 columns (SerialID,
SerialText)
ControlSource = SerialID
NoOfColumns = 2
ColumnWidths = 0"; 1" (Hides the SerialID column)

The user will only see the SerialText values displayed in the listbox, so selection is
easy...
However, lstSerialID, while displaying the SerialText to the user, really stores the
SerialID in lstSerialID... which is really the value you wnat to "capture" to your
SerialID table field.
--
hth
Al Campagna
Candia Computer Consulting
Microsoft MVP - Candia, NH USA
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."



"FilemakerPro_Developer" wrote in
message ...
Hppay New Year.

I have a form that is perfect except I have a list box to a related
table/value list.
In this form the list box shows the value list properly but when the user
selects the option it returns the serialID not the value which isn't very
helpful to the user.

I don't want to recreate the form to add the related value list table. I
just want the value typeA or typeB in the list instead of the serial number 1
or 2 so the user knows what type of data entry it is. Can you fix it with a
calculated field and do I add a 2nd field to the form?
--
Janis

Al Campagna wrote:

Microsoft MVP

Excellent! Congratulations, Al.

--
Steve Schapel, Microsoft Access MVP

Thank you Steve!
And thanks for your kind comment on the private NG, and... all your help over the years!
--
Al Campagna
Candia Computer Consulting
Microsoft MVP - Candia, NH USA
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."

"Steve Schapel" wrote in message
...
Al Campagna wrote:

Microsoft MVP

Excellent! Congratulations, Al.

--
Steve Schapel, Microsoft Access MVP