Kevin,

Thanks, the join works and displays what I want but...

Unfortunately when I do a save as below I get an error:
// Save the DataSet (the GridView automatically binds back)
this.Save(this.oSurveyDue, dsSurveyDue);

InvalidOperationException was unhandled by user code.
Dynamic SQL generation is not supported against multiple base tables.

I assumed you wanted me to modify the SQL passed to the this.GetDataSet() in the bizobj. Should I have done this someplace else?

FYI, an ugly solution that did work was I put a similar but disabled dropdownlist in the itemtemplate.

Thanks, Ted

>Ted,
>
>>My template field dropdownlist is bound to a status table with a status code & description. I want to update the gridview table with the status code but display the status description in the grid after updating.
>>
>>If I may speak VFP/VMP I wish to implement a picklistvalid but not expose the underlying FK's/codes.
>
>In this scenario, you need to have the DataTable bound to your GridView return both the code and the description from the back end (by means of a join). That way the ItemTemplate label can bind to the description text rather than the code. This will require you to update the description when a user selects an item from the DropDownList.
>
>Best Regards,