Skip to main content
Known Participant
August 20, 2009
Question

inserting data into multiple tables using one form

  • August 20, 2009
  • 1 reply
  • 878 views

Is there a way to use datainsert wizard to insert data into multiple tables. OR what i need to add in the code to add data in another table other than the one defined in datainsert wizard.

thanks

This topic has been closed for replies.

1 reply

Participating Frequently
August 20, 2009

If your version supports it, write a stored procedure.

Lon_Winters
Inspiring
August 21, 2009

I've seen this issue come up a lot, and personally I've never found a clean way to do it.  The best I found was a tutorial that showed you how to use the insert behavior and edit it by hand.

But I have to ask, are you absolutely sure you need two tables?

Known Participant
August 21, 2009

Do you have link to that tutorial ?