Quote:
|
the problem is when a user deletes a record, gaps in the numbering are left.
|
please give me one reason why you think this is a problem? it is absolutely not a problem and this practice is probably used in nearly all db designs.
i think you just need to know that it is OK to have gaps in numbers that represent an ID field.