Duplicate Values help

[johnwayneoftheseas]

I have a subform on a main form that details the following:
- School Type (Elementary, High School, University)
- School Name
- Year in School (Freshman, Sophomore, Junior, Senior)
- Year (Year that the student was a Freshman, Sophomore, Junior, Senior)

I changed School Type and Year in School to combo boxes on the form.

Everything looks and works great until I try to add a second line, when I get the error that says "The changes you requested were not successful because they would create duplicate values in the index, primary key, or relationship."

I've made sure that things are not indexed (save "Individual," which is the foreign key from tblIndividuals where the - you guessed it! - main individual's information is stored). What am I doing wrong?!

Thank you!!

 

[boblarson]

What do you have in your Master / Child links for the subform container (control on the main form that houses the subform on the main form)?

 

[johnwayneoftheseas]

Link Master Fields: IndID (on tblIndividuals)
Link Child Fields: Individuals (which is IndID)

 

[boblarson]

Can you post a screenshot of your relationships (if you've set them)? Or, just post the database.

 

[johnwayneoftheseas]

Sure, here it is:
http://picasaweb.google.com/lh/phot...authkey=Gv1sRgCP_4hfOmy4TGvAE&feat=directlink
I'll look for the way to post the database. (Though I admit it's probably the least effective way to organize data.)

 

[boblarson]

Your tblContacts and tblSchool have a ONE-TO-ONE relationship with tblIndividuals so it isn't going to let you add more than one to either of those.

 

[johnwayneoftheseas]

Ack! Thank you. I can't believe I missed that! Thanks so much!