Mysterious Error Message (1 Viewer)

I'm really stumped :banghead: on my lame attempt to create a database for our organization, a homeowners association, because of an error message I'm getting by merely clicking on a subform; the error message says: "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 structure is as follows: Main Form (from Members table); connected on a 1-1 relationship with a subform (from Properties table); three other subforms (from Payments, Residents & Vehicles tables) connected by 1-many relationship with the main form.

Can anybody help me get unstuck in this hole? Thanks much

Can you post a copy of your database-- you'll have to make a zip file because of your post count?

You should read/work through these

http://www.rogersaccesslibrary.com/forum/uploads/5/12-Steps_to_Better_Databases.zip

http://www.rogersaccesslibrary.com/Tutorials/Entity_Relationship.zip

Thanks much for your prompt reply and willingness to help.

The size of my file exceeded the cap imposed by the site - it has already reached 4.1 mb Would there be a workaround, perhaps, so you'll be able to see the file?

Did you do a compact and repair, then make a zip file?

jdraw said:

Did you do a compact and repair, then make a zip file?

Click to expand...

Yes, I did.