createTrigger

[mike009]

hi all i have a proble creating atrigger
here ar my tables

1- product
productid (primary)
price
...

2-orderline
orderID(foreign to order table)
productid(foreign to product table)
priceperunit
...

3-order
orderid(primary)
customerid(foreign to customer table)
salesmanid(foreign to employee table)

4-customer
customerid (primary key)
...

now i have to create a trigger that when a new product inserted
every customer will receive one with a price of 0

how can i create this one coz as you see there are 2 tables between product and customer
thx

[chazzy]

what database are you using?

[mike009]

Ms Sql Server

[Hack]

Ms Sql Server

What version?

[mike009]

2000