Hi,
I have a table which contains fields called EmployeeID, nSN. While insert record, I need to get the max value of nSN of the particular employee in table, increase its value +1.
I faced problem that, more than one record have same nSN value.
How could I prevent this?
Thank you
I am not the most powerful man in this world.
I am not the worst man in this world either.
I just as same as all of you.
I still need to learn from my mistakes...