I have developed an application that has been up and running for several months now. Recently I made a simple change to one of the forms by changing captions and labels.
Now in the re-deployed version, users are getting a "You cannot add or change a record because a related record is required in table [table name]" error message when they try to save their changes.
I have a one-to-many relationship between two tables of a MS Access database. When I step through the code, the primary key and foreign key values are identical. The data adapter for the parent table updates just fine. But then the error occurs when the child table adapter tries to update.
What could be the cause of this?
Now in the re-deployed version, users are getting a "You cannot add or change a record because a related record is required in table [table name]" error message when they try to save their changes.
I have a one-to-many relationship between two tables of a MS Access database. When I step through the code, the primary key and foreign key values are identical. The data adapter for the parent table updates just fine. But then the error occurs when the child table adapter tries to update.
What could be the cause of this?
