>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";
>
That is the ticket. Thanks
>>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.