create trigger ProjectDetail_trigger on ProjectDetail for insert ,update as
begin
declare @fid int
declare @pid int
declare @fName nvarchar(20)
select @fid=fid,@pid=pid from inserted
select @fname=fname from flow where fid=@fid
update Project set Pstate=@fname where pid=@pid
end