Problem w/Auto-Numbered Primary Key

[Lykus]

I am filling the sender & recipient fields for a logistics company's Invoice table by drawing from a single address table. I enter "new" addresses using two forms (one for the sender field, one for the recipient field) that populate the common address table and the Invoice table's record. As I attempt to create a new address the address table's primary key generates an auto-number, but when I go to close the form after the entry I get this prohibitory error message:

"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."

What am I doing wrong? Is there a better way to do this?

[FishVal]

I am filling the sender & recipient fields for a logistics company's Invoice table by drawing from a single address table. I enter "new" addresses using two forms (one for the sender field, one for the recipient field) that populate the common address table and the Invoice table's record. As I attempt to create a new address the address table's primary key generates an auto-number, but when I go to close the form after the entry I get this prohibitory error message:

"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."

What am I doing wrong? Is there a better way to do this?

Are you sure there are no any other field indexed with "no duplicates"?

[Lykus]

Yes, that was the problem! I am surprised I over looked that. I'm sorry to trouble you for something so trivial. Thank you very much for your help.

[FishVal]

Yes, that was the problem! I am surprised I over looked that. I'm sorry to trouble you for something so trivial. Thank you very much for your help.

Don't worry. You didn't trouble me at all. You are quite welcome.