>I just ran across something that seems to work [based on a Foxpro Advisor tip]:
>
>keyfield+IIF(DELETED(),BINTOC(RECNO()),SPACE(4))
>
This has unanticipated results at times, especially when RI rules are considered. In many cases, the primary key is also embedded in any number of child records, and PACKing a table results in strange things happening when you need to cascade the effects of permanent deletion or record RECALL (you strand children; if you use the default RI generated by VFP, you have problems with RI and composite primary keys IAC.)
Just say
NO to recycling primary keys...