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

inserting data into multiple tables using one form

New Here ,
Aug 20, 2009 Aug 20, 2009

Copy link to clipboard

Copied

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

Views

811
Translate

Report

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

Copy link to clipboard

Copied

If your version supports it, write a stored procedure.

Votes

Translate

Report

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

Copy link to clipboard

Copied

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?

Votes

Translate

Report

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

Copy link to clipboard

Copied

LATEST

Do you have link to that tutorial ?

Votes

Translate

Report

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