Hello Stephen,

Dot Net David's suggestions are excellent. I would also add that alternatively, if you really, really want to continue pulling multi-joined table data simply for display yet only update one of those back-end tables, you can change the BusinessObject's UpdateSelectStatement field to reference just the one updatable table:

//Make sure you add a filter clause that can't 
//return data (e.g., PK = -1), since this is only used to get 
//schema info for the commandbuilder.
this.UpdateSelectStatement = "SELECT * FROM YourUpdateTableName WHERE FilterClauseThatReturnsNoData";

Hope that helps,
---J

>I have data for the datagrid that really needs to show the lookup columns. Yet when I write the dataset back, it errors on it's multi-table aspect.
>
>It's an inventory piece with an InventroyType, as well as a Vendor column.
>
>I can display the data with the 3 table join, I just can't save a new record.