Update Records

[Guest]

The problem I am having is that I have a form (a real one that reflects a real world paper form). The fields all come from different tables in the database. I want to update the data in the entire form with one click of the submit button. I can't seem to figure out how to make the Update Record Server Behavior see beyond a single table. Is there a way around this?

I certainly don't want to set it up so that a person fills out one field and then has to press submit to update one field and then go on to the next one and do the same thing. Can I use the recordset to write the UPDATE SQL and have it inserted in the right place? Is there some kind of javascript that would automatically submit a single field to a database when the user moves on to the next field? If so, is this practical since the page would possibly have to refresh each time the user moves to a new field. Not a fun or easy to use situation.

Those are my questions. Please Help.

Thanks

[Newsgroup_User]

what language are you using

--
Paul Whitham
Certified Dreamweaver MX2004 Professional
Adobe Community Expert - Dreamweaver

Valleybiz Internet Design
www.valleybiz.net

"zavidp" <webforumsuser@macromedia.com> wrote in message
news:e7n072$ge$1@forums.macromedia.com...
> The problem I am having is that I have a form (a real one that reflects a
> real
> world paper form). The fields all come from different tables in the
> database.
> I want to update the data in the entire form with one click of the submit
> button. I can't seem to figure out how to make the Update Record Server
> Behavior see beyond a single table. Is there a way around this?
>
> I certainly don't want to set it up so that a person fills out one field
> and
> then has to press submit to update one field and then go on to the next
> one and
> do the same thing. Can I use the recordset to write the UPDATE SQL and
> have it
> inserted in the right place? Is there some kind of javascript that would
> automatically submit a single field to a database when the user moves on
> to the
> next field? If so, is this practical since the page would possibly have
> to
> refresh each time the user moves to a new field. Not a fun or easy to use
> situation.
>
> Those are my questions. Please Help.
>
> Thanks
>

[Guest]

I am using ASPVBscript and an Access database.

[Newsgroup_User]

There is an old Ultradev article on the Adobe site that shows you the steps
to write data to two tables at the same time, using the code created by DW
however it is very convoluted. Julian Roberts has an excellent article on
how to do it a lot simplier at
http://www.charon.co.uk/content.aspx?CategoryID=27&ArticleID=47

--
Paul Whitham
Certified Dreamweaver MX2004 Professional
Adobe Community Expert - Dreamweaver

Valleybiz Internet Design
www.valleybiz.net

"zavidp" <webforumsuser@macromedia.com> wrote in message
news:e7ot9o$gn4$1@forums.macromedia.com...
>I am using ASPVBscript and an Access database.

[Guest]

I have tried the script on the Charon Link that you recomended and I can't seem to make it work. I get an error message that says: Object Required on the line with the addnew command.

Can you tell me what I might be doing wrong. I tried to include the code but I got a message that says this is user to user and not for support so I don't know what to do now.