Insert to two table
I want to insert products to two different tables (product) and (translate) at the same time.
The product table contains all data.
The translate table contains unique translation fields, and is linked to the product table.
Step 1: Insert to product.
Step 2: Insert to translate. (When writing to this table, I want the id to be retrieved from product.pro_id and filled in translate.tra_proID.)
How do I do this?
Here are the tables: