Subject | PK question |
---|---|
Author | Didier Gasser-Morlay |
Post date | 2002-03-12T17:19:07Z |
Hello all,
First of all thank you for the quality of this list, I am reading all
the emails & the answers are always clear & precise. This is highly
appreciated.
Now my question: I am trying to create a primary key with three fields :
FieldA, FieldB and FieldC. The three fields are not null obviously. In
my mind, the uniqueness is evaluated by combining the three fields
values and the result must be unique. It seems though that as soon as
fieldA has got the same value in more than one record, then the PK
creation is rejected.
I know this is not the right thing to do (I should have a small PK, with
only one field), but this is a very small table & I need to check the
uniqueness of three fields out of four.
How can I do this ?
Didier
First of all thank you for the quality of this list, I am reading all
the emails & the answers are always clear & precise. This is highly
appreciated.
Now my question: I am trying to create a primary key with three fields :
FieldA, FieldB and FieldC. The three fields are not null obviously. In
my mind, the uniqueness is evaluated by combining the three fields
values and the result must be unique. It seems though that as soon as
fieldA has got the same value in more than one record, then the PK
creation is rejected.
I know this is not the right thing to do (I should have a small PK, with
only one field), but this is a very small table & I need to check the
uniqueness of three fields out of four.
How can I do this ?
Didier