When deleting a patron that has an address that was cloned from another patron the delete succeeds, but when deleting a
'parent' patron whose address has been cloned to a 'child' patron, the delete fails.
When I updated the actor.usr_address table, setting the usr foreign key to the 'child's' usr id, I was able to delete the
'parent' patron.
Ian suggests writing a script or SQL to find and clone these addresses and set the pointers correctly. Does this mean
making a new record in the usr_address table for every 'child' patron who shares the address of the 'parent' patron and setting the usr foreign key to the 'child's' usr id?
When deleting a patron that has an address that was cloned from another patron the delete succeeds, but when deleting a
'parent' patron whose address has been cloned to a 'child' patron, the delete fails.
When I updated the actor.usr_address table, setting the usr foreign key to the 'child's' usr id, I was able to delete the
'parent' patron.
Ian suggests writing a script or SQL to find and clone these addresses and set the pointers correctly. Does this mean
making a new record in the usr_address table for every 'child' patron who shares the address of the 'parent' patron and setting the usr foreign key to the 'child's' usr id?