Christian,
If you need to show address on the same level as name then it will need to be in the same table for binding. In the select statement used to pull information from the backend, add a join between the two tables and include address in the selected fields. That way you can view the address when binding the table. If you use the CommandBuilder, then when you perform the update, set the UpdateSelectStatement property to the select statement without the address field. That way only the company table be used to generate the statements.
>The example from earlier:
>A Company table has : key | name
>An Address table has : key | address
>
>When I do it like you suggested, I get the "name" and then a "+" that I can click and see "address" in a new record of the grid.
>
>I would like to see: column1 = "name", column2 = "address".
>Isn't that possible?
>Thank you for helping.
>Regards
>Christian Kirschberg
-----------------------------------------
Cathi Gero, CPA
Prenia Software & Consulting Services
Microsoft C# / .NET MVP
Mere Mortals for .NET MVP
cgero@prenia.comwww.prenia.comWeblog: blogs.prenia.com/cathi