I have a form with three controls, a button and a datagrid.

The grid is bound to a dataset table.

When the button is pressed, a new row is added to the dataset table.

The datagrid table contains 3 int columns, plus an identity column. 2 of
these int columns are FK's to lookup tables.

In the SQL for the table I used an inner join to the lookup tables so grid
becomes populated with the data I want them to see (i.e. text not numbers).

When I insert the new row, because the row is uncomitted, the text columns
display as null. Once the new rows are comitted they display as expected.

I can understand why this happens, but are there any simple workarounds for
this, so I can display the data I want?

--
Cheers,

James Goodman

Not to be catty about an answer, but there is never a simple solution with a
JOINed query bound to a datagrid. If you are using it solely for display
purposes, I could see it, but anything requiring an insert or an update is
only going to lead to grief. You probably want to google some previous
issues on this.

"James Goodman" <jamesATnorton-associates.co.ukREMOVE> wrote in message
news:%(E-Mail Removed)...
>I have a form with three controls, a button and a datagrid.
>
> The grid is bound to a dataset table.
>
> When the button is pressed, a new row is added to the dataset table.
>
> The datagrid table contains 3 int columns, plus an identity column. 2 of
> these int columns are FK's to lookup tables.
>
> In the SQL for the table I used an inner join to the lookup tables so grid
> becomes populated with the data I want them to see (i.e. text not
> numbers).
>
> When I insert the new row, because the row is uncomitted, the text columns
> display as null. Once the new rows are comitted they display as expected.
>
> I can understand why this happens, but are there any simple workarounds
> for this, so I can display the data I want?
>
> --
> Cheers,
>
> James Goodman
>