Stop duplicate records in Access 2010

I created a form in Access with linked tables to data on a SQL server.  When the user enters data into the form (Access) the data is duplicated on the form.  So one line of unique data now turns into two.  I created the form using Form Wizard and chose all the coloums from my Table.  Any suggestions would be great on how to not have the form duplicate the records.  
LVL 1
SargentControlsAsked:
Who is Participating?
 
Jeffrey CoachmanMIS LiasonCommented:
"I created a form in Access with linked tables to data on a SQL server."
Then, can you explain the structure of these tables and the links involved...?
Post the ERD (Entity relationship diagram)

There is nothing the form wizard can do that will create duplicate records automatically (unless the code was perhaps modified after the fact).

I would suspect the table relationships first.
0
 
mayankagarwalCommented:
you can define a primary key on the table. or before inserting the row in the table you can check for the existing data if at all it exists then throw an error to the user
0
 
SargentControlsAuthor Commented:
None
0
 
Jeffrey CoachmanMIS LiasonCommented:
None what?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.