u0093This entry already exists in the following tables......."

Hi,

I’m using code to call up a form containing a user-defined document object. The object has both a header and lines. I use the find method to get the data from the database into the form. I am then updating the matrix with code. This changes the form to the Update mode and the user is then able to update the database consistent with the new data. As long as I don’t add a row to the matrix, the things work as expected. If I have to add a row to the matrix because the new data has an additional line, Business One will not save the updated form. It gives an error message, “This entry already exists in the following tables(MYTABLENAME) (ODBC-2035)”. I have not yet tried removing a row but will. Does anyone know a way around this so that the user can update the database?

Thanks,

Mike