How to display a value from one table based upon a value in anothe

[Bobby]

I am creating an Inforpath 2003 form using a Microsoft Access 2003 database
(will be converted to SQL 2005 when completed.) I am currently using some
list tables in this database that allow for simple numeric values to be
stored in the main data tables, but allow long display names in the form.
For example:

lstGenders
GenderID Gender
1 Male
2 Female

A selection of "Male" allows "Male" to be displayed on the form, but a 1 is
stored in the database. The problem I am experiencing is that I need that
field to appear on a second view as read only. With a text box linked to the
dataset, it is displaying the GenderID "1" instead of the Gender "Male". Is
there a way, either via XPath or some other code that will allow me to change
the numeric value back to the text value on the form for display purposes
only? I want to keep the data numeric, but to allow it to display in the
form as text. I know I can do it by using another drop down box containing
duplicate data, however, all other instances need to be read only. Thank you
in advance!

 

[S.Y.M. Wong-A-Ton]

I'm not sure how you've set up your form template, but you can add a
secondary data source to the table and then do a lookup for the Gender based
on the GenderID. The principles of this technique are explained in:
http://www.bizsupportonline.net/inf...ook-up-data-sharepoint-list-rules-filters.htm