My primary key is a Serial Number that is entered in the first operations form, OP 20, creating a new record. The first form fills out a handful of columns for that SN with data. In OP30, I would like to append that record by adding data to the next set of columns. I tried to set up a combo box from which you can select an existing serial number, and then write to that record. However, it is trying to overwrite the Serial Number, or maybe write a new one, which is giving me an error. Is it possible to use the combo box to select the row to be written to using the SN, but not actually write the SN value to the table?
Exact error text: "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."