Insert record from one db to another db

Which database are you using?

If it is Access then I would say you will to use a method similar to the one
Win suggested or invent another crafty way. If you are using SQL Server then
you can use a Linked Server.

Without the type of database it is very difficult to offer help.


"Simon Gare" <sg@simongare.com> wrote in message
news:eo74c1$152$1@forums.macromedia.com...
> Hi all,
>
> need to retrieve a record from a table using varID (tblBookingForm) in one
> database and insert in into another table (tblNetServ) in another database
> on the same server, leaving the original record where it came from. Cant
> get
> my head round it though MX doesn't seem to allow for 2 active connections.
>
> Anyone help?
>
> Regards
> Simon
>
> --
> Simon Gare
> The Gare Group Limited
>
> website: www.thegaregroup.co.uk
> website: www.privatehiresolutions.co.uk
>
>

On Fri, 12 Jan 2007 04:54:42 -0000, "Simon Gare" <sg@simongare.com>
wrote:

>Hi all,
>
>need to retrieve a record from a table using varID (tblBookingForm) in one
>database and insert in into another table (tblNetServ) in another database
>on the same server, leaving the original record where it came from. Cant get
>my head round it though MX doesn't seem to allow for 2 active connections.
>
>Anyone help?
>
>Regards
>Simon

How about:

retrieve the value from the first database

save it into a session variable

stuff the value of the session variable into the second database

Win
--
Win Day, Wild Rose Websites
http://www.wildrosewebsites.com
winday@NOSPAMwildrosewebsites.com
Skype winifredday