Problem saving data entered in form (db attached)

Ken_C

Registered User.
Local time
Today, 14:52
Joined
May 22, 2006
Messages
11
Can someone go through my forms and help me figure out why I cannot submit the entered data. Whenever I try to test my system and enter in inspection information I get an error that 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 and try again."


Steps:

1.) Type the given sample account number in the blue box
2.) Click "Search Acct #" button
3.) Click "Test" button
4.) Enter random info on the test form
5.) Read error message
6.) Help Ken_C :D

Thanks in advance :cool:
 

Attachments

Last edited:
Ken_C said:
Can someone go through my forms and help me figure out why I cannot submit the entered data. Whenever I try to test my system and enter in inspection information I get an error that says something about indexes.

Steps:

1.) Type the given sample account number in the blue box
2.) Click "Search Acct #" button
3.) Click "Test" button
4.) Enter random info on the test form
5.) Read error message
6.) Help Ken_C :D

Thanks in advance :cool:

Can you post the specific error message please.
 
Added the error message and finally loaded the database.
 
What it's telling you is that you have set a unique index on a field(s) possibly a primary key that prevents you from entering duplicate data into that/those fields. What your doing is adding duplicates. Check your test data to see if that is what your doing.
 
Figured it out. I was referencing a key field from the wrong table.
 

Users who are viewing this thread

Back
Top Bottom