Creating a Delete Record Form....

[ArcherSteve]

First, I have to explain what this DB is being used for. It is used by an archery tournament administrator to enter archer information (i.e name, address,etc. and scores.) When a new archer is inputted, it creates a unique ID using the DMax() function. Now, what i need to be able to do is delete an archer.

If the archer (let's just call him "archer1") has an ID of "x" and I delete archer1 from the database, is there a way to have the other archers whose ID>x to to subtract one in order leave out any "jumps" in numbers? If i delete ID 2, can ID 3,4,5,...etc. now be called 2,3,4...etc. ?

I'm still learning all the tricks of access so any help is more than appreciated.

Thanks,
ArcherSteve

P.S. If this is more of a code thing than a form thing, my apologies. I wasn't quite sure where to put it.

 

[namliam]

Primary keys should not be changed after creating the records. They link all information back to the main (archer) table and you will loose data integrity...

BR

 

[ArcherSteve]

I realized that yesterday....i think i'll be better off doing it a different way but thank you for your response.