No. There are 3 records selected. Then I select 1, return to the calling form passing the id of the record I selected. The calling form displays and acceptance message, and if approved deletes the record. If I then click the delete button again, it should show the remaining 2 records that have not been deleted yet.

There is some setting or something else that I'm missing, as I can click another button after deleting, then go back to delete and the 2 records will correctly show.

>If you have Set deleted on then dleeted records are not detected by the deleted() fn. Is this the case?
>
>
>>This one is killing me. I've looked at it for a while but don't understand the results:
>>
>>

>>select p32pur1.vendorcode, p32pur1.transno, p32pur1.vdrinvno, p32pur1.itemdesc,;
>> p32pur1.aptype, p32pur1.batchno, p32vend1.vendor ;
>> FROM P32Pur1 ;
>> JOIN P32Vend1 ;
>> ON P32Pur1.Vendorcode = P32Vend1.Vendorcode ;
>> WHERE aptype = 'DC' and EMPTY(p2gl) and ! deleted() .and. at('REVERS',comment)=0 ;
>> into cursor curInv READWRITE
>>

>>
>>This "Select" is run from a button click on a form with a private data session, which calls a form with a default data session that displays the results of this query and you can select 1 for deletion.
>>
>>In this example, I click on the button and 3 records are returned. If I select one of records for deletion, then click the button to attempt to delete another one, the tally from the above query is 0 records. But the other 2 records not deleted should be displayed. If I click the button again, the display will look like I expect.
>>
>>I've verified that Ansi and Exact are what they should be.
>>
>>Anyone have any suggestions?
>>
>>Thanks,
>>
>>PF