Hi Christian,

Based on your question, I am assuming that you are using the CommandBuilder to create your update/insert/delete statements (the default for Mere Mortals). There is a property in the BusinessObject class called UpdateSelectStatement that can be set to the select statement to be used by the CommandBuilder to create the update/insert/delete statements. You can set this property to not include the field from the other table. The DataSet will still include the field by the saving of the record will ignore the field.

>How do we get data from more than one table into a grid, if the tables are 1-to-1?
>
>A simplified example.
>A Company table has : key | name
>An Address table has : key | address
>
>And we want a grid with : name | address
>
>As far as I know the grid cannot databind to more than one dataset like, column1 = companyDataset.name, Column2 = addressDataset.address.
>The query could of course select both name and address, but then saving the data gets difficult.
>Any help or recommendations appreciated.