They have identical fields... The new db does not have a pk, but rather a memNumber field which is also in the old db... The old db does have a pk field.
The issue is I need to delete records out of the old db if they are not in the new db...(which means a member has cancelled) and insert any new members from the new one into the old one... <sigh> ~~ Stephenie > |-----Original Message----- > |From: Harkins,Patrick [mailto:[EMAIL PROTECTED]] > |Sent: Wednesday, October 16, 2002 12:02 PM > |To: CF-Community > |Subject: RE: Db merge question > | > | > |I would create a new db and link the two tables that you > |want to merge but that part is optional. > | > |Then I would write a union query on the two tables which > |will automatically not include duplicates - see UNION query > |documentation in Access. This only works if the two tables > |have identical fields.... There are plenty of side > |considerations, but this might work for you. > | > |Patrick > | > | > |> -----Original Message----- > |> From: Stephenie Hamilton [mailto:[EMAIL PROTECTED]] > |> Sent: Wednesday, October 16, 2002 11:42 AM > |> To: CF-Community > |> Subject: Db merge question > |> > |> > |> I am not at my best today and am writing an app to merge 2 access > |> db's.... I have the insert of new records covered, but am > |fuzzy on the > |> best way to check to see if a record in the old db is not > |in the new > |> db, which means that record needs to be deleted from the old db... > |> > |> What is the best way to do this? > |> TIA > |> > |> ~~ > |> Stephenie > |> > |> > |> > |> > |> --- > |> Outgoing mail is certified Virus Free. > |> Checked by AVG anti-virus system (http://www.grisoft.com). > |> Version: 6.0.401 / Virus Database: 226 - Release Date: 10/9/2002 > |> > |> > |> > | ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=5 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_community Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
