Hi John. You can test a records deleted status using the DELETED() function. So you could also create an index on the expression DELETED() and search for a value of .T. on this index to find the first deleted record. Using this deleted index would also sort all the records marked for deletion together.


>I have a form where the user can enter a new title name, delete, edit, etc...
>However, records in my company's DB are never deleted, just marked for deletion. When the user enters a title that has been used before it causes an error that the unique key has been violated. My question is: how can I check a tables "marked for deletion" records so that I can have a form pop up informing the user that this Title has been used before and if they'd like to RECALL it. I know how to recall a deleted record... but I don't know how to search through them.
>
>Thanks!