Cascade Update utility in SM

cascade-003

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:

https://s3.amazonaws.com/smhelpcenter/smhelp940/codeless/index.html#tailor/data_management/concepts/cascade_updates.htm%3FTocPath%3DSystem%2520Administration|Tailoring|Data%2520management|Cascade%2520Updates|_____0

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s