Hi,

I'm setting up a database which will act as an online petition book. So I will be recording names, email addresses (not displaying, but just collecting to validate that only one signature per person), location and comments.

I want to know if it is good practice (or necessary?) to auto increment an ID # for each signature?

If so, if I ever have to delete signatures (spam or bad language), will I need to reorder all the ID's in the table and is this simple?

Many Thanks.

GH

if it is good practice (or necessary?) to auto increment an ID # for each signature

Good practice, Yes. Necessary, not always, but when you are dealing with data that can be duplicates (names for example) it is.

If so, if I ever have to delete signatures (spam or bad language), will I need to reorder all the ID's in the table

No.