>Hi all
>Can anyone clear up the difference between primary and candidate indexes?
>
>Thanks.

Dean;

A primary key is unique and identifies a specific record. A candidate key is also unique, however it relates to an entity other than the primary key. An example would be a customer code, social security code, etc. If a violation of uniqueness occurs due to a duplicate – the system user must know. It has been known to have duplicate social security numbers issued. When this occurs it must be resolved. Hope you get the general concept.

By the way I would never create a table without a primary key!

Tom