Step 1:
Create 3 tables for an example :
Table 1- SheetTable, with Two fields Sheetid and sheetname
Table 2-PartitionTable with three fields sheetid , partitionid and sheetsize
Table 3-SheetPartitionTable with two fields partitionid and Shape
Step 2:
1) Create a relationship between SheetTable and PartitionTable (Ex:PartitionTable.SheetID==SheetTable.SheetId)
2) Create a relationship between PartitionTable and SheetPartitionTable(EX:SheetPartitionTable.PartitionID==PartitionTable.PartitionID)
Step 3:
1) Create Cascade DeleteAction between SheetTable and PartitionTable
2) Create Cascade+Restricted DeleteAction between PartitionTable and SheetPartitionTable
Step 4:
Open SheetTable and delete the matched record with PartitionTable.
Automatically the matched record from SheetTable , PartititonTable and SheetPartitionTable will be deleted .
No comments:
Post a Comment