How to delete data from related tables when deleting a data item?

[shiz]

1. I have an actual time table. name: u_actuant_time 2.The second table is actual time weekly. name：u_actual_time_weekly 3.The related fields of the two tables are the release_date field (which refers to the release date of actual time weekly based on the release date of actual time) 4.When I want to delete data from the actual time table now, I also want to delete the relevant data from the actual time week table. And when deleting, send a message agreeing to delete all related records. How can it be achieved?

[aizawaken · Accepted solution]

Hi@shiz ,

In Advance tab, you can write a script of deleting relative records in relative table, and what you want do can be achieved.

This means that you have to write a script by your self,,,

And please refer this page, and I hope it would help you.

[aizawaken · Accepted solution]

Hi@shiz ,

In Advance tab, you can write a script of deleting relative records in relative table, and what you want do can be achieved.

This means that you have to write a script by your self,,,

And please refer this page, and I hope it would help you.

[shiz]

@aizawaken hello

Based on that Page, I have written the following script. But  'actual time' table and 'actual time weekly' table are only one associated field is Week starts On . And I want to use ‘Week starts On’  and 'assignee_to' to  delete  'actual time weekly'.

Is the following writing correct? Where do I need to modify it?

[shiz]

@aizawaken dears,

After executing the operation：

Click delete button after：

Actual time of data is delete,but actual time weekly is not delete

actual time weekly data:

What's going on here?

[aizawaken · Accepted solution]

Hi @shiz ,
Sorry, I have short time now,,, so let me point out 1 thing as below:

current.sys_id is the ID field of the u_actual_time_weekly table.
so, you should check with date value in the record. Could you check this point?