如下语句中。
create table forerefer
(id int primary key,
 department varchar(200)
)
go
 
create table refer
( forereferid int references forerefer(id),
  address varchar(200)
)

insert into forerefer values(1,'admin')
insert into forerefer values(3,'sunshine')
insert into forerefer values(5,'window xp')

insert into refer values(1,'广州市')
insert into refer values(3,'深圳市')
insert into refer values(5,'珠海市')

有没有办法，当在forerefer中删除id为5的记录，会自动删除refer表中的forereferid为5的记录呢？