I have a combo box that auto populates address fields, based on the Vendor ID that is chosen.
All the field son the form are based on a header table for the shipment, the combo box is controledby the vendor table in order to auto populate the address fields.
Now the form will not allow you to save a new record. It comes back with this long 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 entires and try again."