Forms hamper data entry

[Guest]

I created a table, to enter data I created a simple form, now when entering
data using this form, I get a message: "The changes you requested to the
table were not successful because they would create duplicate values in
Index, Primary key or relationship ..." ... How can one have that data?
TypeID in number obviously would have 1,2,1,3,2,1 ... its getting too hard to
understand. Data entry directly in tables poses no problem then why thru
forms? Thanks

 

[Joseph Meehan]

I created a table, to enter data I created a simple form, now when
entering data using this form, I get a message: "The changes you
requested to the table were not successful because they would create
duplicate values in Index, Primary key or relationship ..." ... How
can one have that data? TypeID in number obviously would have
1,2,1,3,2,1 ... its getting too hard to understand. Data entry
directly in tables poses no problem then why thru forms? Thanks

Is there a related table? If so related on what fields? What is the
relationship?

Do you have a primary key field defined? If so why? If so is it a
autonumber type field?

Is it possible that the form is somehow updating or appending the same
data twice, maybe once on command and once automatically?