Nov 27, 2007

"The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship."

This error is related to the database not being able to handle the update or insert the Server Behavior that it is trying to perform.

The Server Behavior is attempting to update or insert into a database table's auto number field. The database can't handle an external input into an Autonumber field. When a record is inserted the autonumber is defined automatically, so when the update or insert behavior tries to place another item into the field it fails.

When applying the Insert or Update Server Behavior, ensure that no information is modifying an autonumber field.