Plus your inserted statement plus the following paragraph (select @@ identity as' identity ")
INSERT INTO TABLE (Field1, Field2, Field3)
VALUES ('Accountant', 12,125)
SELECT @@ identity as 'id'
So after you insert success, return a value, which is the ID you just inserted, use it when you open it.
Select * from table where id = xx
It can be positioned to the original record.
