I'm trying to do 2 transaction in the same page. I'm using 2 form. Form1 is for insert record in table and form2 is to delete the data that retrieve in the page. I'm using dreamweaver to code it. The insert statement done but the delete statement from form2 not work but when I run the page there is no error.

I attach my coding for your info. If somebody can help me solve this problem, it's a happy day for me...

How are you submitting your second form because from the looks of the file attached it can't be submitted..... if it can't be submitted then the values will never be available for requesting...

Try the attached

Thank q for your reply. It is not what I mean. What I want is the 2 transaction done at the same time. When the user click the Sokong button both insert and delete statement take place.
The senario is retrieve data form table A after user click Sokong button the data will be insert in table B and the retrieving data will be delete in table A.

Can it be done....

Check the attached, should be basically what you want