Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Cannot add more than one record in a subform!

Status
Not open for further replies.

mattpearcey

Technical User
Mar 7, 2001
302
GB
I have a subform set up so that in will log the call that are made/taken from a particular person. So, the form has the name and id at the top, then a subform that i want to cntain the infomration about the calls made/taken by that person. However, i can enter one record in the sub-form, but when i enter another, it come up with the following error which does not allow me to go any further:

'The changes you have made 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.'

What do i do from here? Do i delete the fields in the subform that show the name, or how can i allow for duplicates?
Thank you for your help already.

Matt Pearcey
 
In table design go to the field, go to data type, then
at the bottom, general tab, at the bottom again is the
index when you click in that field you have to pick
yes (duplicates ok)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top