|
yeah, the purpose of an id field is just so that each record has a unique piece of data you can identify it with.
as you pointed out, the id's will have gaps when you delete them, but why do you need to number them?
is it only so you can show the users a nicely numbered list? if that is the case, then you should just number it when you print out the data to the user.. you don't have to use a database field for that.
__________________
Mike
|