Thank you Dennis! I'll give it a whirl and let you know how it goes. Jerry - MerriamFamilyTree.org
On 8/18/2011 8:51 AM, Dennis M. Kowallek wrote: > On Thu, 18 Aug 2011 01:32:16 -0400, Jerry<jerrysemailgro...@gmail.com> > wrote: > >> What I'm doing is transferring or moving the >> one source name, which is the book called Merriam Genealogy in England >> and America, from the NAME field into the UNSPECIFIED field instead. > > UPDATE tblSR INNER JOIN tblSX ON tblSR.IDSR = tblSX.IDSR SET tblSX.Type > = 0 WHERE ((tblSX.Type=1) AND (tblSR.SrcTitle="Merriam Genealogy in > England and America")) > > Try it on a copy of your database and see if it does what you want. You > may have to tweak the SrcTitle if that's not exactly what you named it. > > In English, it says... > > Change the source detail to point to UNSPECIFIED (Type = 0) on any > record that is pointing at NAME (Type = 1) AND has a master source title > of "Merriam Genealogy in England and America". So, in effect, it MOVES > the detail from NAME to UNSPECIFIED if the title is... > > You get the gist. > > If there are records with that title pointing at NAME that you don't > wish to move, more conditions will have to be added to the WHERE clause. > > Fairly safe query as long as you try it on a copy of your database first > and verify that it does what you want. MS Access will tell you how many > rows it is about to update, so if that doesn't look correct you can > abort. But really no need to if you are trying it on a copy. > Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages after Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyusers.com/ Archived messages from old mail server - before Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp Follow Legacy on Facebook (http://www.facebook.com/LegacyFamilyTree) and on our blog (http://news.LegacyFamilyTree.com). To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp
