I need to insert a group of data into table1 and at the same time update table2 field. Anyone know how to do it. By the way, I'am using VWD.
You run two separate queries, one for the INSERT and one for the UPDATE. The alternative is to program it in SQL, possibly as a trigger, but it depends on wht you're really doing.
Please: Don't forget to click "Mark as Answer" on the post that helped you. That way future readers will know which post solved your issue.