About ID identities
Normally an Id identities to Yes is supposed to go from 1..2..3..4..5..etc. which mean it increment by 1 each time.
However, when entering the Review records.. i push the Enter key in the middle of one record which cause some kind of error message saying there was no commit, etc.. so i continued entering the record then went to the second line and used Ctrl+R to save the record by executing the query.
But it passed from 1 to 3... at the Id. Is there a way to rearrange the Ids.. so it go from 1 to etc..