Cascading Delete in AppSheet

[pheninux]

Hi everyone,

I have a question regarding managing data deletion in AppSheet. I want to know how to ensure that when I delete a transaction, all corresponding entries in the TransactionProduct table are also deleted, along with the client associated with that transaction.

Here’s a brief overview of my data structure:

• Clients Table: Contains a Row ID for each client.
• Transactions Table: Contains a Row ID for each transaction and a reference to the client.
• TransactionProduct Table: Contains a Row ID, a reference to the transaction, and a reference to the product.
• Products Table: Contains a Row ID for each product.

What steps should I take to implement cascading deletes so that when a transaction is deleted, all related records in TransactionProduct are also removed? Additionally, how can I ensure that the client associated with that transaction is handled appropriately?

Thank you for your help!