How to insert record in two different tables on a button clk

Question

I have two tables product(productId,productName,productRate) and ID(id)...i want to insert record on a button click.I want to insert record into product table and want productId to insert in ID table on same button click.