ADONet Quest.-Datagrid ID Numbers

[Guest]

How to I get the relating table Text entries to show in the datagrid instead
of the corresponding relating table row id numbers?

The DataMember/DataSet of the DataGrid is a relational MS-Access table
(called: "Main"). This Main Table has several linked lookup tables. The
problem is the DataGrid shows (for table columns with lookup tables) the row
ID numbers (keys) of these linked/relational tables instead of the text
entries for those rows.

Steve

 

[Cor Ligthert]

Steve,

Your question is not clear for me, however it can be that you are looking
for

datagrid1.Expand = -1;

Just a guess

Cor

 

[Guest]

Previously, before I started making an interface for my Access database
through Visual Studio, I used the MS-Access lookup wizard to key on the Row
ID (i.e. Autonumber) of the lookup table but show the corresponding Text
field for the Row ID.

For example,
if the lookup table to my Main table was an address table and if the address
table had a John Smith living at 5 Center Street with a Row ID of 1 and
another John Smith living at 20 Red Road with a Row ID of 2, my Main table in
Access would show the two different John Smith's strings associated with the
two different addresses, but when I load the Main table Visual Studio DataSet
into the DataGrid the DataGrid shows the row ID numbers 1 and 2 and istead of
the string names John Smith.

Hope this helps

Steve

 

[Cor Ligthert]

Steve

Can you show a little piece of code.
I really cannot get what you want.

I know almost nothing from ms-access so telling about that helps for me
nothing, I don't know of others understand that exactly.


Cor