I have a main table for ServiceOrder using autonumber to generate a unique identifier every time a new records is inserted it is the PK, how can I insert this value in the Mian table and in other table that i have a 1 o many relation the second table i store the details(parts) of the Main table at the same time. I need to have value in both table every time a new record is inserted in the main table, I have try to use commit trans and roll back feature, but i do not know how to do that , if the PK unique identifier in the main table were not autonumber it would be easy. the other idea is to create a table only to generate autonumber value and then insert that value in the main table and the dependency . Any idea? i appreciate a lot you help. Thanks