I am having the ff problem:

My application runs in a multi-user environment. There is a table that
users are to create a new record in with a unique key. The key is generated automatically by incrementing by 1. When two or more users
access that table, they end up with duplicate records (that is records with the same key)

Please help