The Cascade Update utility allows Administrators to maintain database integrity and consistency by altering or deleting the data in one or more dependent files to match changes made to data in a source file.
For example, incident records are linked to the contacts table by the contact name (probsummary, contact.name = contacts, contact.name). If someone were to edit the contact record and change contact.name, the associated incident records would lose their link and become orphaned. You could set up a Cascade Update record to monitor the contact.name field in contacts and change the contact.name field in related incident records to match accordingly.
For details, please take a look at below KM: