>>>Can anyone clear up the difference between primary and candidate indexes?
>
>>Both forbid you to make duplicate values. For practical purposes (in Visual FoxPro), you can use them interchangebly - in theory. ...
>
>
>THis is what I thought. I saw no real difference between the two.
>
>Thanks
Well, you can even create a relationship (one-to-many) using a candidate, instead of a primary, index.
But it helps to keep things organized.
BTW, the framework I use (Visual Extend,
www.devigus.com) requires each table to have a primary key for certain functions, such as audit trail.
Hilmar.
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)