# Cascade Updates
When updating a database, it is essential to also update all related and dependent records to maintain data consistency, accuracy, and integrity.
PowerTable allows you to automatically cascade updates across all related tables using an automation workflow.
1. Select **Setup > Automations.**
Setup automation
2. Create a new automation workflow by clicking on **Create.**
Create Automation
3. Click **Add Trigger** or directly select any of the suggested triggers to configure the triggering event.
Add Trigger
4. Let us assume you need to update relevant records in another table whenever a new record is created. In this case, you can select the trigger, 'When a record is created'. A trigger event is added.
Trigger event added
5. You can define additional properties and add conditions to further customize your trigger and make it more specific.
{% hint style="info" %}
You can add multiple conditions and combine them using AND/OR, for an event to initiate the action.
{% endhint %}
6. Click **Add action** and then choose the required database action that you want to perform. Let's update a record in another table whenever a new record is created in the current table.
Update record in another table
7. Add the connection information, schema, and table name for the table you want to update simultaneously. You can specify any conditions, such as updating only certain records in the table.
Update table details and conditions to update
8. Add the required row values to be updated in the table.
Add row values
9. Click **Save Changes** after configuring the row values.
Save configuration
10. The automation workflow is now set up successfully. You can use the pencil icon to name this workflow for easier identification. You can also add more actions to this cascading update event, such as sending an email or a Microsoft Teams message.
Workflow automated
---
# Agent Instructions: Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.
Perform an HTTP GET request on the current page URL with the `ask` query parameter:
```
GET https://docs.powertable.com/explore-powertable/automation/cascade-updates.md?ask=
```
The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.
Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
