2 forms on page -- one submit button?

Report · Aug 31, 2008

Using Dreamweaver CS3 I've created a page that basically has 2 forms on it. Each form is connected to its own recordsource / database (but display information regarding the same customer).

Right now there's a "submit" button underneath each form.

I'd really like to be able to set this up so that there is only one "submit" button and it updates both databases from the form data once it is pushed.

Is this possible? If so, could someone please point me to some directions on how to do it?

Any help would be greatly appreciated.

Thank you.

Report · Aug 31, 2008

It is possible, but the easiest way would be to combine the two forms into a
single one. Why not do it that way?

--
Murray --- ICQ 71997575
Adobe Community Expert
(If you *MUST* email me, don't LAUGH when you do so!)
==================
http://www.projectseven.com/go - DW FAQs, Tutorials & Resources
http://www.dwfaq.com - DW FAQs, Tutorials & Resources
==================

"GlennC02108" <webforumsuser@macromedia.com> wrote in message
news:g9ejc0$rge$1@forums.macromedia.com...
> Using Dreamweaver CS3 I've created a page that basically has 2 forms on
> it.
> Each form is connected to its own recordsource / database (but display
> information regarding the same customer).
>
> Right now there's a "submit" button underneath each form.
>
> I'd really like to be able to set this up so that there is only one
> "submit"
> button and it updates both databases from the form data once it is pushed.
>
> Is this possible? If so, could someone please point me to some directions
> on
> how to do it?
>
> Any help would be greatly appreciated.
>
> Thank you.
>

Report · Sep 01, 2008

I am new to Dreamweaver and I used the Update Form Wizard to create the page. I would like one form that updates information in two different tables but wasn't sure how to do it.

Report · Sep 08, 2008

I have also have a problem posting to two different tables on one submit. However, I cannot get the second table in the database to update. I tried consolidating two forms into one. In my last attempt I tried naming the $insertSQL statements. Any suggestions would be appreciated. I have reasons why I violated database normalization rules so please don't pick that logic apart. I have attached the code.