Datagrid binding problem

I gave a datagrid bound to a parent-child reltionship, working correctly.  However the field that is showing in the datagrid is the code that's actually in the table, I want to show a different field.

So, for example, if I have 2 tables, parent table of Orders, child table of customers, and the field I'm showing is the state field, my datagrid is showing what's being stored in the table:  the state codes, of AL, AZ, AK, etc.  What I want to show is the full state names, linked by another 'states' table.

Now I can do this on a combobox, set the display member and the value member, but I don't see how to do this on a datagrid.  Any help is greatly appreciated, thanks!

Answer this question

Datagrid binding problem

pankaj sharma103086
I've never had reason to take it to that level, so this is just a guess, but can't you just add another relationship and drill down to the needed column
Datagrid binding problem

Answer this question