I need to insert new records into 2 or more tables. I want them to be both inserted, or neither inserted if an error occurs. I believe a "transaction" is what I need.<BR><BR>I can insert the rows in one of two ways, either I can build the rows in a dataset, and then execute an UPDATE. OR I can just do a "begin transaction", execute a SQL INSERT for table 1, and then execute a SQL INSERT for table 2 and then do a "transaction commit"<BR><BR>My question is this, do I still need to do a transaction if I&#039;m doing the dataset way? does the dataset UPDATE automatically start a transaction? or do I need to nest the dataset UPDATEs within a tranaction manually?<BR><BR>Tom Maiden