>Hi All
>
>Everytime if a user delete a invoice,customer code,,,, the data need to be packed. In multiuser environment is quite troublesome...
>Any idea ?
>
>Thanks In advance


Don't reuse primary keys. There is an article on my website, www.craigberntson.com, that will tell you how to create unique IDs.