I'm just learning .Net, I've been programming in VB6 for many years. I've found alot of examples for add/edit/delete a single table. In VB6 ADO you could load multiple tables into a recordset using the join command. Then manipulate or modify the data.

I've found how to retreive multiple tables like,
Code:
Da = New OleDb.OleDbDataAdapter("Select groups.groupid,groups.userid,lots.groupid,lots.lotid from groups inner join lots on groups.groupid=lots.groupid order by groups.groupid asc", DB)
But the only way I have found to update is to use seperate Update commands for each table.

Is this the only way to update? If not could someone point me in the right direction.

Thanks