Re: updating two databases with one form submit (WAS: RE:)

[AustralianAccommodation.com Pty. Ltd.]

thanks for the suggestion regarding the insert trigger however I have no
idea how I do that so your further guidance would be appreciated please keep
in mind that for the moment all this is being done using access 200 database
not sql
----- Original Message -----
From: "Jeff Beer" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, September 28, 2000 9:31 PM
Subject: RE: updating two databases with one form submit (WAS: RE:)


You might want to put an insert trigger on your 'primary' database tables.
When a record is inserted, the trigger would insert the same record into the
other database.  Also, same thing goes for updates and deletes.

-----Original Message-----
From: AustralianAccommodation.com Pty. Ltd.
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 28, 2000 5:29 AM
To: CF-Talk
Subject:


I have dual sites running on 2 separate cf servers is there a way that I can
update both databases when I am using one of my database update forms so
that with one click of the form submit button it will take the form data and
update both databases at the same time



Kind Regards

Claude Raiola (Director)
AustralianAccommodation.com Pty. Ltd.
Website: www.AustralianAccommodation.com
Email: [EMAIL PROTECTED]

----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.


------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.