Error: "Will cause duplicate values etc"

[Robin Chapple]

I have made some changes to a form and when I attempt to add a new
member with just the last name to the [LastName] field I get the
error:

"This will cause duplicate values in and index, primary key or a
relationship etc"

I desperation I have deleted the relationships, I have made the field
"No Index" and it is not a primary key.

The field [MemberID] is an auto number field and the only key field.

Searches on Google have not found similar symptoms.

Thanks,

Robin Chapple

 

[Robin Chapple]

I have now attempted to add a new record directly to the table with
the same result.

Getting desperate.

Robin Chapple

 

[Robin Chapple]

I have now made a separate database with only a copy of the membership
table in it.

The result was the same.

I then deleted all but the first 25 records. Now all is well.

Now I am really mystified.

Robin Chapple

I have now attempted to add a new record directly to the table with
the same result.

Getting desperate.

Robin Chapple

I have made some changes to a form and when I attempt to add a new
member with just the last name to the [LastName] field I get the
error:

"This will cause duplicate values in and index, primary key or a
relationship etc"

I desperation I have deleted the relationships, I have made the field
"No Index" and it is not a primary key.

The field [MemberID] is an auto number field and the only key field.

Searches on Google have not found similar symptoms.

Thanks,

Robin Chapple

 

[Robin Chapple]

I have now divided the copy table into three roughly equal parts and
each of them will accept new entries

I have now made a separate database with only a copy of the membership
table in it.

The result was the same.

I then deleted all but the first 25 records. Now all is well.

Now I am really mystified.

Robin Chapple

I have now attempted to add a new record directly to the table with
the same result.

Getting desperate.

Robin Chapple

I have made some changes to a form and when I attempt to add a new
member with just the last name to the [LastName] field I get the
error:

"This will cause duplicate values in and index, primary key or a
relationship etc"

I desperation I have deleted the relationships, I have made the field
"No Index" and it is not a primary key.

The field [MemberID] is an auto number field and the only key field.

Searches on Google have not found similar symptoms.

Thanks,

Robin Chapple

 

[Ken Snell [MVP]]

What are the indices in the table itself? Is the FirstName field part of an
index? For example, do you have an index that consists of both the LastName
and the FirstName? Is the LastName that you're trying to enter already in
the table in another record?

 

[Guest]

Robin

Has someone set up an index using the Surname and another field with a
property set to Unique - in design view go to indexes and have a look. This
would stop duplicate entries but may not show in the normal field properties

Sheila

 

[Robin Chapple]

Ken and Sheila,

It was an index problem but it is still a mystery that the form had
been working. Each member has an ID number with the international
organisation and this is often blank until an infrequent return is
received. It is set to "No Duplicates".

Some how the default value on this field had been changed to zero and
that caused my problem.

So I still have an index, no duplicates allowed but blanks are OK.

Is this an acceptable technique?

Many thanks for your help. I was tearing my hair out, and there isn't
much to start with.

Regards,

Robin Chapple

 

[Ken Snell [MVP]]

I believe that your new index will work fine for your needs... of course,
the "proof is in the pudding" as you work with it... < g >