Index Error Message

[martha.dempsey]

I have check every field for duplicate data and I have
reduced the number of indexes in my form to 24 (which is
suppose to be the max).

I am still getting an error msg : The changes you
requested to the table were not successful because they
would create duplicate values in the index, primary key or
relationship. Change the data in the field or fields that
contain duplicate entries and try again.

I only have one table so it can't be relationship and my
primary key is Yes,No duplicates by default.

The only thing that is of the same value are my Option
Groups Yes=1, No=2. The index for my OGs are Yes,
Duplicate OK.

Any suggestions?
martha

 

[TC]

I have check every field for duplicate data and I have
reduced the number of indexes in my form to 24 (which is
suppose to be the max).

Huh? Indexes go on tables, not on forms. And the maximum number per table is
32 (from memory), not 24. What do you actually mean by "reducing the number
of indexes on [your] form"?

I am still getting an error msg : The changes you
requested to the table were not successful because they
would create duplicate values in the index, primary key or
relationship. Change the data in the field or fields that
contain duplicate entries and try again.

I only have one table so it can't be relationship and my
primary key is Yes,No duplicates by default.

The message means that your table has a primary key, and/or other so-called
"unique indexes". The primary key, and each unique index, each comprise one
or more fields. You are probably trying to save a new record where the
values in those fields, duplicate the values in an existing record in the
table. That is not allowed. You can not save two records with the same
values of the primary key field(s), or the same value of the unique index
field(s).

The only thing that is of the same value are my Option
Groups Yes=1, No=2. The index for my OGs are Yes,
Duplicate OK.

There's no such thing as an index on an option group. You are getting
confused between >controls< - the things like option groups, buttons and
textboxes etc. that you see on a form - and >fields< - the underlying
storage elements of the database. Indexes are for fields - not controls.

HTH,
TC

 

[martha.dempsey]

I meant on my table and yes you are right it is 32 per
table. Problem solved when I access the index and remove
the primary key and some of the other fields. Now my form
works creating a record and allowing me to go to a new
one. Thanks for making me re-research indexes.

Posted automatic numbering and concatenation. Any
suggestions?
martha

-----Original Message-----

"(e-mail address removed)"

in message

I have check every field for duplicate data and I have
reduced the number of indexes in my form to 24 (which is
suppose to be the max).

Huh? Indexes go on tables, not on forms. And the maximum number per table is
32 (from memory), not 24. What do you actually mean by "reducing the number
of indexes on [your] form"?

I am still getting an error msg : The changes you
requested to the table were not successful because they
would create duplicate values in the index, primary key or
relationship. Change the data in the field or fields that
contain duplicate entries and try again.

I only have one table so it can't be relationship and my
primary key is Yes,No duplicates by default.

The message means that your table has a primary key, and/or other so-called
"unique indexes". The primary key, and each unique index, each comprise one
or more fields. You are probably trying to save a new record where the
values in those fields, duplicate the values in an existing record in the
table. That is not allowed. You can not save two records with the same
values of the primary key field(s), or the same value of the unique index
field(s).

The only thing that is of the same value are my Option
Groups Yes=1, No=2. The index for my OGs are Yes,
Duplicate OK.

There's no such thing as an index on an option group. You are getting
confused between >controls< - the things like option groups, buttons and
textboxes etc. that you see on a form - and >fields< - the underlying
storage elements of the database. Indexes are for fields - not controls.

HTH,
TC

Any suggestions?
martha

.