how can I insert extra product info into extra db table?

Hello,

I have created a new database table to store additional information about each product. It is linked(primary key) to the zen_products table by the products_id. I want to make sure that, when I add a new product, a new row will be added to the new table and the new product_id will be added to the new table.

I am not sure where the "Insert Into" query is. If anyone could help me out, I would appreciate it.

Look at how the music files are used in the modules of the admin to see how each works with multiple tables and compare to the original files for regular products for the /product vs /product_music ...

Note: files not over ridden are in the default:
/modules