This would work. However, it implies that PK's are recycled, which is NEVER a good idea.


>
>Ed gave you two valid options. There is one more: you can 'discard' field value for deleted records, e.g. replacing old value with some surrogate negative number.