Hi All,
I need to create a custom table wich will have a serial number as the primary key. Whenever the table is updated with new entries this serial number needs to be incremented by 1. I wanted to know if there is any procedure to auto generate this serial number. I do not want to do the max of the serial number and increment it by 1 because it will lead to problems when more than one person is updating the entries exactly at the same time. I dont even want to go for date and timestamp, I want serial numbers such as 1,2,3 and etc. or something similar. Please let me know how to achieve this.
Thanks in advance.