data grid problem

[Stephen]

hi all

i have a datagrid that returns all the rows from a table. It fires ok except
one field returns the numeric value of the lookup field not the description.
heres the corresponding piece of code:
With txtTransType

..Alignment = HorizontalAlignment.Right

..HeaderText = "Transaction Type"

..Width = 100

..MappingName = "TransTypeId"

..ReadOnly = True

End With

tsTrans.GridColumnStyles.Add(txtTransType)

the table return a numeric 1 instead of "Checking"...... any ideas?

Steve

[Rob Oldfield]

I'm guessing a bit here, but I'd guess that the table actually stores just
the numeric value of the code. You have another table that says that the
value 1 means 'Tracking'?

If that's the case then I'd suggest pulling the data back from a query/view
containing both tables, and returning the text your after.

(Or, if it's something like an mdb table with lookups set up within the
design of the table, then add the new table.)
"Stephen" <St******@xjohnstontrading.com> wrote in message
news:OO**************@TK2MSFTNGP09.phx.gbl...

hi all

i have a datagrid that returns all the rows from a table. It fires ok except one field returns the numeric value of the lookup field not the description. heres the corresponding piece of code:
With txtTransType

.Alignment = HorizontalAlignment.Right

.HeaderText = "Transaction Type"

.Width = 100

.MappingName = "TransTypeId"

.ReadOnly = True

End With

tsTrans.GridColumnStyles.Add(txtTransType)

the table return a numeric 1 instead of "Checking"...... any ideas?

Steve