Access and SQL Server enable the relationship between tables and automatically update or delete the data in the parent table.

1. access enables the relationship between tables and automatically deletes sub-table data after the parent table data is deleted:

On the tables page, right-click and choose relationships... -> In the displayed relationships window, select the table to be joined, and double-click the blank location in the relationships window. In the displayed edit relationships window, you can see the enforce referential integrity option. select cascade... now.

2. SQL server enables the relationship between tables and automatically deletes sub-table data after the parent table data is deleted:

Create foreign key-> foreign key pop-up window foreign key relationships window-> You Can See insert and update secification-> below is the corresponding settings. (available SQL statement settings)