Access and SQLserver enable the relationship between tables and automatically update or delete the parent table data

1. Access enables the relationship between Tables and automatically deletes sub-table data after the parent table data is deleted: on the Tables interface

1. access to enable the relationship between Tables and automatically delete sub-table data from the parent table. On the Tables page, right-click "Relationships... -In the displayed Relationships window, select the expected table, and double-click the blank location in the Relationships window. In the displayed Edit Relationships window, Enforce Re is displayed.

1. AccessEnableBetween tablesLink, AndImplementationDeleteParent tableDataAutomaticDeleteSub-tableData:

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 ServerEnableBetween tablesLink, AndImplementationDeleteParent tableDataAutomaticDeleteSub-tableData:

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)