U
UnhappyAggie
I have a table where the SSN is the primary key. I have a form which is used
to add new records. When I enter a duplicate SSN in the form it stores the
record in the table with no error message or other warning. I thought it was
not possible to get duplicate primary keys.
I tried to enter the duplicate key in directly in the table and it was
blocked. I can only create the duplicate when I enter using the form. I
have tried it three time and it happened every time. I viewed the data in
the table and the duplicate was there. I am open to suggestions.
to add new records. When I enter a duplicate SSN in the form it stores the
record in the table with no error message or other warning. I thought it was
not possible to get duplicate primary keys.
I tried to enter the duplicate key in directly in the table and it was
blocked. I can only create the duplicate when I enter using the form. I
have tried it three time and it happened every time. I viewed the data in
the table and the duplicate was there. I am open to suggestions.