What I'm curious about is if the following is possible. Consider these two sets of tables:

# report
+----+-------------+------+
| id | report_name | year |
+----+-------------+------+
| 1  | RPT         | 2018 |
| 2  | RPT         | 2019 |
| 3  | RPT         | 2020 |
+----+-------------+------+

# report_details
+----+-----------+----------------+---------+---------+
| id | report_id | report_name_fk | year_fk | details |
+----+-----------+----------------+---------+---------+
| 11 | 1         | RPT            | 2018    | ABC     |
| 12 | 2         | RPT            | 2019    | DEF     |
| 13 | 3         | RPT            | 2020    | GHI     |
+----+-----------+----------------+---------+---------+

And:

# report
+----+-------------+------+
| id | report_name | year |
+----+-------------+------+
| 1  | RPT         | 2018 |
| 2  | RPT         | 2019 |
| 3  | RPT         | 2020 |
+----+-------------+------+

# report_details
+----+----------------+---------+---------+
| id | report_name_fk | year_fk | details |
+----+----------------+---------+---------+
| 11 | RPT            | 2018    | ABC     |
| 12 | RPT            | 2019    | DEF     |
| 13 | RPT            | 2020    | GHI     |
+----+-----------+----------------+---------+---------+

Lets say I want to change the report_name in the table report for year = 2020 to just TST. I want that to CASCADE to related tables like report_details and update the report_name_fk for that year too.

Is that possible to with either of these table sets and how would the model be built?