Hi all, What will be the best way to implement auto increment field. I dont want to use auto increment feature, as it only appends the numbers but doesn't check for the values deleted. Suppose, following are the values in table
1 abc 2 bcd 3 cde . . . . . . 9 xyz now if 2nd and 3rd rows are deleted, an autoincrement field will still assign 10, 11, 12.... to the new values, while I want it to assign the values deleted from the table first. What will be the best way to implement it? Thanks in advance Nitin
