Bill,

Realize the difference between all of the index options. Primary and Candidate are almost exactly the same type of index - they enforce uniqueness in the index as well as the table for the given expression. The regular index enforces no uniqueness at all.

The FoxPro "unique" index is confusing to most, particularly to newcomers. It allows duplicates in the table, but only one unique entry is allowed in the index. It does have its uses, but to most folks, it's an option that might as well not exist.

Are you using unique indexes? I have to say I haven't used one in my 7+ years of using FoxPro and VFP.