subform problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i made a subform but i am unable to enter in more than one line. An error
message comes up whenever i try to save
"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 data, remove
the index, or redefine the index to permit duplicate entries and try agin".
i have edited to indexes but i don't know what else to do it still doesn't
want to work for me. Any suggestions?
 
JennBard1 said:
i made a subform but i am unable to enter in more than one line. An error
message comes up whenever i try to save
"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 data, remove
the index, or redefine the index to permit duplicate entries and try agin".
i have edited to indexes but i don't know what else to do it still doesn't
want to work for me. Any suggestions?
Click to expand...

Open the table in design view and click on the field that causes the
problem.
Below, in the properties section, in 'indexed' choose, yes, allow
duplicates.

Although indexed fields are usually duplicate protected because they
provide a unique reference for each register of data.

Hope it helps.
 
i made a subform but i am unable to enter
in more than one line. An error
message comes up whenever i try to save
"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 data, remove
the index, or redefine the index to permit
duplicate entries and try agin".
i have edited to indexes but i don't know
what else to do it still doesn't
want to work for me. Any suggestions?
Click to expand...

I don't understand what you mean by "I have edited to indexes".

Perhaps you have not included the Table's unique key in the Form embedded in
the Subform Control. As the message clearly indicates, whatever you are
doing is trying to save a record with a Key that is identical to the Key of
a Record already in the Table. From that perspective, examine the Table, the
Form embedded in the Subform Control, and the main Form.

Jeff's suggestion might allow you to save, but there is a very high
probability that an Index defined as unique (or a Primary Key) was created
in that manner _for a purpose_ and that purpose would be defeated if you
change the definition of the Table.

And, with no more information than you provided, some hints and tips on how
to go about debugging the problem are going to be all that is possible.

Larry Linson
Microsoft Access MVP
 
Back
Top