how to give Primary Key Increamet and decreament automatically?

[mparunk]

Hi ,
I am new in ms access , I want make one database about office register. That is Have done . I gave primary key for auto increment serial number . That is working fine. Now problem is some times I want delete client name in between table .That is maybe first row or 5th row or anywhere . at the time the row deleted which is i was selected but the primary key is not update . for example I want delete 8th row . after deleting I not seen 8 in primary key place i have seen only ....,5,6,7,9,10...... etc. So please tell me how to give auto increment and decrement in the primary key......


thanks
regards
Arunkumar M


India.

Sorry for my grammatical mistake....

[Micron]

You cannot use Autonumbers this way. They do not have to be sequential and they are only for identifying a table row - it is not important that they increase or decrease sequentially. It is not important if there are gaps. In a multi-user database, you cannot even ensure there are no gaps when records are created. If you need them to be sequential, you need another way of creating a record ID. I think you need to research "database table normalization" - it is very important and I think it relates to your problem.

[orange]

Why are sequential numbers important to you? They are not necessarily import to the database management system.
Autonumbers only provide unique values -- not necessarily incremental and not necessarily positive.
As Micron said --review Autonumbers.

[June7]

As already stated, don't use autonumber to generate an identifier that has meaning to users. If you must have a sequential, no gap reference identifier then will need VBA. Generating custom unique identifier is a common topic. Search forum.

Why delete client record? Deleting records should be a rare event. Once they're gone, they're gone for good (unless you have backup files). Better would be to tag a client as "Inactive" and filter records.