Setting Index in primary key

[Milamber]

Hello everybody.
is it possible to have an Index that has Duplicates OK in
the primary key without it stuffing up? I have tried
this many different ways and it still dosen't work. I
am trying to set the Index to accept duplicates under a
primary key. Can it be doen or is it a pipedream? Also
what does Relationship must be on the same number of
fields with the same data types when they alredy are?
thanks

 

[Allen Browne]

By definition, a primary key uniquely identifies each record.
You cannot have duplicates in a primary key.

 

[John Vinson]

Hello everybody.
is it possible to have an Index that has Duplicates OK in
the primary key without it stuffing up? I have tried
this many different ways and it still dosen't work. I
am trying to set the Index to accept duplicates under a
primary key. Can it be doen or is it a pipedream? Also
what does Relationship must be on the same number of
fields with the same data types when they alredy are?
thanks

I share Allen's concern here. Is this a single-field or a multifield
Primary Key? Just what do you mean by "under"? A relationship must
indeed use the same number of fields and they must be of matching
datatypes - you can't plug a two-prong parallel plug into a three-hole
perpendicular socket!