To generate An Autogenerated field
-
I want autogenerated column every time I save Information. In case i delete a record then, Eg The auto generated Nos are 1 2 3 4 5, and i remove 3 and 4 then the 5th record must automatically take the place of the 3rd record(just like what happens in Excel)How do i do it?
-
I want autogenerated column every time I save Information. In case i delete a record then, Eg The auto generated Nos are 1 2 3 4 5, and i remove 3 and 4 then the 5th record must automatically take the place of the 3rd record(just like what happens in Excel)How do i do it?
If the autogen'd numbers are the primary key, then you don't get to do that. Once an autogenerated number is used it is never used again, even if it has been deleted. The only way your going to accomplish this is if you generate the number yourself and keep track of which numbers have been used and which hasn't. More trouble than it's worth... RageInTheMachine9532