Christian,
Usually the best way to handle this is to not allow editing directly in the grid. Display the SQL results in the grid as read only and then have either an edit tab or form to make any changes. This way you can set the binding source of each field seperately.
There is a good example of this in the MM .Net Developer's guide under Jump Start: Windows Form Application. There is a List tab which displays the results of a query and then a Properties tab to make any changes.
Kind Regards,
Mat
>I have asked this question before, and still have not found out how to do this.
>
>If there is a database with an address table and a company table, like this:
>
>Company: companyID, name, ...
>Address: addressID, address, ...
>
>and the grid should show:
>Grid: name, address
>
>so the company name and the address is in the same row of the grid. How could you do this?
>
>Now, if I make a SQL join, I get one dataset and I can show that in the grid, but then I can't update the data with the savedataset-method.
>
>If I make two queries, one for each businessobject, I could save the data, but then I can't show the data in the grid as I would like.
>
>This is in a Windows Form application.
>
>Any suggestions? Thank you in advance.
>
>Regards,
>Christian Kirschberg