Duplicate Records Problem

[Thorson]

I currently have a table (tblBreeding) set up with 4 fields: "EarTag" "Date"
"Bull" "UnitLocation" The same animal may be bred to the different or same
bull more than once, however the table is not allowing me to enter in the
same animal "EarTag" more than once; when I try to a box pops up:

"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 again."

The field "EarTag" indexed property is set to "Yes (Duplicates OK)". The
table, tblBreeding, is also set up in a relationship with another table
(tblEarTag). The join properties are set up so the "EarTag" record must first
be in tblEarTag before tblBreeding, Enforce Referential Integrity and Cascade
Update Related Fields are both checked. I don't know what I have set up
wrong, any suggestions?

 

[SuzyQ]

You may have EarTag set up as a unique index - possibly the primary key.
Open the table in design mode and then see if EarTag is your primary key. If
it is, add another field that is the autonumber type and use that as your
primary key. Then you should be able to have multiple EarTag records. If
EarTag is not a primary key, then click on the menu option View -> Indexes
to see if EarTag has an index that is set to no duplicates or look at the
indexed property to see that same thing. If it is set to no duplicates -
change that setting. - Not an access expert, but have had similar problem in
the past.

 

[SuzyQ]

Sorry, I missed the last part of your post.