>When creating such an index in VFP you must remember that this alternate (or candidate key) must also be unique. You can´t therefor create a value, delete it and re-insert it. Accoring to VFP the deleted value is still present in the database and you must pack the database before re-inserting.
Yes, you can: filter the index on
not deleted(). However, this is less troublesome with candidate indices than with the primary ones.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)