MAX ID - TRANSACTIONS

[Nick Chan]

i have some data to insert in some tables

after inserting some data in Table 1, I get the generated ID by "SELECT =
MAX(ID) FROM TABLE1"

how to avoid the ID conflict? I am using begin transaction and commit =
transaction. Is it sufficient?