I have solved this myself
i created a table called booking like this
create table booking(
bookingid int identity(1,1) primary key,
itemid int foreign key references item.item(itemid),
shopid int foreign key references shop(shopid),
quantity int
);
now i create the trigger for insert as
create trigger [shop].[trigoninsert] on [shop].[stock]
for
insert
as
declare @stockremaining int;
declare @itemid int;
declare @shopid int;
select @stockremaining=stockremaining from inserted;
select @itemid=itemid from inserted;
select @shopid=shopid from inserted;
if(@stockremaining<=10)
begin
insert into booking values(@itemid,@shopid,10);
end