>How to create a primary or candidate KEY ?
>
>VFP help is not clear about this issue
>
>Moises
Primary keys are defined through indices (indexes).
In the table structure, for example, with MODIFY STRUCTURE, click on the field, and select an ascending index in the corresponding combobox. Then go to the "Index" section, and define the index as primary, or candidate.
You can also create an index directly in the "index" section. You may have to do this if an index doesn't exactly correspond to a field, but rather, is a combination of more than one field.
I suggest you also read my introductory article on primary keys, to learn about different strategies for creating primary keys. Universal Thread Magazine, May 2002.
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)
