Inserting and Updating Records at the same time

[juniorbee]

Hi,
Ive created a form which inserts a record into one table within the database,
but i also need it to increment a field in another table of the same database,
can anyone tell if and how this is done.

Thanks

Using DWMX/JS/ASP

[messiah944]

Hi, I'm also having problem as yours when I'm using ASP/JS/ASP. Other websites
showed it can be done using ASP/VBScript. Perhaps Macromedia should put this in
as when dealing with database, this is mostly needed. I wonder if MX2004 have
this feature? The Command are not doing well either and Ms Access can't do
Stored Procedure. Have you solved it?

[juniorbee]

no, this is the third time ive asked this and no-one has replied to it, ill assume no-one knows how it can be done.