run insert 1 table and update 1 table at a same form

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.
0
Jerrytkc
5/7/2007 8:57:47 AM
asp.net.access-datasource 4679 articles. 0 followers. Follow

1 Replies
659 Views

Similar Articles

[PageSpeed] 55

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.

Jeff


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.
0
jeff
5/7/2007 11:18:17 AM
Reply: