Sir, 

In my asp.net project. I have to get a no from a table and then insert an entry in that table.  Using the no I have to insert a line in another table.  

Problem is that if after success of 1st insert the 2nd insert fails then the first insert is of no use.  How to handle this situation 

Situation :

table 1 :  qno, refertable

I get the max qno , insert an entry with max qno +1, name of refertable

table 2 : detailed entry with a field for qno whcih is same we got from table1+1

table 2 name can change with respect of work... means around 10 different tables can be used as per need. 

Pl. guide