[RESOLVED] A Question About Crystal Reports

[MonkOFox]

Join that table in your query then. Select the numeric value as "LetterNumericValue" and the actual letter as "LetterValue".

select twn.number as "LetterNumericValue", twl.letter as "LetterValue"
from tablewithnumber as twn join tablewithletters as twl on twn.number = twl.number

Then you can use that in your vb.code.

me.combobox1.DataSource = mydataSource
me.combobox1.displaymember = "LetterNumericValue"
me.combobox1.valuemember = "LetterValue"

Justin