>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!


Look at the Help section for the 'SET DELETED' statement. It will explain to you how to retireve and ingnore deleted records in your searches.