>I'm reasonably clear on how VFP uses indexes to prevent duplicate data entry but found out that it apparently applies such index controls to deleted records. Is there a way to set up VFP indexes to bypass or ignore deleted records? All responses are appreciated.
You may try to add a filter on NOT DELETED() for the index.
Chose BINARY for the type of such index.
If it's not broken, fix it until it is.
My Blog