Inserting multiple data in 2 table at same time in MYSQL

See more:

ASP.NET

MySQL

Hello all

I am working with .net and Mysql as database.
Please help me on below query which i am finding from last 2 days.

I have 2 tables

First table: Table1
Auto_ID | FirstName | Address | Status | Table2_ID

Second table: Table2
Auto_ID | Table1_ID | Action_Item | Cur_Status


I have to insert multiple records in Table1 where Table1 and Table2 are interlinked like a single record in Table1 can have multiple entry in Table2.

It is one to many relationship.

And as soon as record is entered in Table2 it auto_id should be updated in Table 1 > within column Table2_ID

I have created below triggers
First trigger to insert record in Table2 when record in entered in Table1
create trigger tr1
AFTER INSERT ON Table1
for each row
begin
Set @Action=new.Action;
Set @Ref_id=new.Auto_id;
Insert into Table2 (Table1_ID, Action_Item, Cur_Status)
Values((Select @Ref_id),'Value1','Value2');
End

Second trigger to update auto_id in Table1 when record in inserted in Table2 through trigger.
CREATE Trigger tr2
AFTER INSERT ON Table2
For each row
Begin
set @Auto_id=new.Auto_id;
set @Cur_Status=new.Cur_Status;
update Table1
set
Table2_ID
= (select @Auto_id), Status =(select @Cur_Status)
where
auto_id=@Ref_No;

End


But after insert records in first table getting below error:
Can't update table ‘Table1’ in stored function/trigger because it is already used by statement which invoked this stored function/trigger.

Please note: My only intention is to insert multiple data in both the table at the same time and maintain the auto_id of second table in first table

Any help is greatly appreciated.