Query Error

Question

Hi,

I am getting this error when i am deleting data from Request table. In request table RequestId is PK and in RequestData table RequestId is FK.

ERROR :::
The conflict occurred in database "XYZ", table "dbo.RequestData", column 'RequestId'

So, How will I write query that when I will delete RequestId from Request Table then automatically all the data will be deleted from the RequestData table for that particular requestId.