Trigger update

[vortex]

Hi,

I need help writing a trigger in MS SQL2000.

The table i am writing the trigger for contains several price lists, one of these price list is the master price list.

When a user addes a new product to the master price list, the trigger needs to duplicate the new product to the other price lists (there could be any number of price lists).

Table looks like this (001 is master price list):
Price_List , Product_name, Description , Price
001 , Test1, Test Description1, 11.00
001 , Test2, Test Description2, 22.00
001 , Test3, Test Description3, 33.00 <= New product
002 , Test1, Test Description1, 11.00
002 , Test2, Test Description2, 22.00
003 , Test1, Test Description1, 11.00
003 , Test2, Test Description2, 22.00

Please help!

thanks