duplicate data on a form

  • Thread starter Thread starter Becky
  • Start date Start date
B

Becky

I'm sure that this is something very basic that I'm
missing, please help! I have a form based on three tables
that I'm trying to utilize for data entry purposes. When I
go to save a new record I get this message "The changes
you requested 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 again". I
cannot find a duplication, what am I doing wrong? Thanks.
 
the message means you have chosen not to have the same value existing twice
in a field

look inside all the separate tables in your query and take a look at the
indexes you have setup for each table
you can find the indexes by clicking on the button with the flashlight or
under view\indexes

bon chance
 
Back
Top