My accounting department just notified me that one of the clients has the id number wrong. A number was transposed. When i try to update it , i get the error that it can't be updated because of the related records.
What is the best way to update this record?
My plan is:
1. check all the tables that may have this id field and run an update on all the different tables to get the correct number in the other tables.
2. break the relationship.
3. update the customer id field
4. re create the relationship