>I have a database in a pricing app. SET DELETED is ON. There are various child records in three related files to the the primary key file in file Primex. When a record is deleted in file Primex and then a subsequent APPEND BLANK is used to append a new record I get the message 'Uniqueness of index file is violated'...how should I handle this ? Packing is a problem in the shared multiuser environment.
>Appreciate any help...Thanks,

My personal preference is to not reuse primary keys for this reason, but it's doable.

You can put a !DELETED() filter on your primary key index.