I am trying to find a search work which describes the scenario of running code but have not been successful
Insert a new row into a table
Retrieve auto number from above and insert this value from above .
There are no unique record except for time stamp . Do I use some Dbo code that can record the auto number recorded in the first insert by simply using Dbo commands . I am sure I have used it before but have lost my work .
In addition what syntax would you use to wrap the code so no inserts are partially done and if so it will roll back both inserts .