data grid problem

  • Thread starter Thread starter Stephen
  • Start date Start date
S

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
 
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.)
 
Back
Top