Thanks, Jim,

I learn something new every day :-)

Jack

>SNIP
>>
>>Important SET DELETED is ignored if the default scope for the command is the current record or you include a scope of a single record. INDEX and REINDEX always ignore SET DELETED and index all records in the table.
>>
>>SET DELETED is scoped to the current data session.
>>
>>In other words, a SEEK is only scoped to a single record and is not affected by the setting of SET DELETED.
>>
>SNIP
>
>Hi Jack,
>
>This excerpt lost me $20. 5 years ago. It simply ain't so with SEEK, even though it *is* scoped to a SINGLE record. In other words DELETED's setting is respected for SEEK.
>
>Jim N