Primary Key

[SteveAlb]

In the last stage of File Normalization process. I want to
change my primary field to another field that will allow
duplicates. But a message appears:
Removing or changing the index for this field would
require removal of the primary key.
If you want to delete the primary key, select that field
and click the primary key button.
I do as the message instructs, but the message still
appears.
What is going on???
TIA
SteveAlb

 

[John Vinson]

In the last stage of File Normalization process. I want to
change my primary field to another field that will allow
duplicates.

EH!?

A Primary Key cannot - BY DEFINITION - allow duplicates. A Primary Key
is and must be unique.

But a message appears:
Removing or changing the index for this field would
require removal of the primary key.
If you want to delete the primary key, select that field
and click the primary key button.
I do as the message instructs, but the message still
appears.

You should be able to select the field which currently has the key
icon, and press the Key icon; this will leave the field in existance
but remove its Primary Key index. You can then select any other field
(PROVIDED IT HAS NO DUPLICATES!) and click the key icon to make this
field the PK.

You'll first need to remove all relationships involving the current PK
field in order to do this.

 

[SteveAlb]

John, you are correct. I missed the obvious.


thanks,
SteveAlb