Auto Enter Serial Number Problem!
I have some troubles with auto enter serial number.
I created a filed with auto enter serial number which generate on creation and starting value 1 then incremented with1.
The problem is when created first record its shows 1, then i created couple of records. But after that i deleted one record. i have currently 4 records, and i want the next record serial number to be 5 but after creation its showing 6.. Is this happened because of the deletion? Is there any way i can get the continuous serial number without breaking it even if i deleted in between?.
Thank you in advance.....