Exit
  • Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
  • 한국 커뮤니티
0

inserting data into multiple tables using one form

New Here ,
Aug 20, 2009 Aug 20, 2009

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

TOPICS
Server side applications
820
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Aug 20, 2009 Aug 20, 2009

If your version supports it, write a stored procedure.

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Advocate ,
Aug 20, 2009 Aug 20, 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?

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Aug 20, 2009 Aug 20, 2009
LATEST

Do you have link to that tutorial ?

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines