Richard, I had a look at this to see if it would work in OpenOffice. In principle it should, although the syntax of the query is quite different - anyone who uses OOo should be able to convert it without difficulty. Unfortunately I was unable to verify whether the procedure works in OOo. This is because I'm an unreconstructed lumper and Source Writer has forced me to be somewhat less unreconstruced, hence my old and new files are not sufficiently compatible to test.
Ron Ferguson _____________________________________________________________________ *New Tutorial* Create Standards Compliant CSS Pedigree web pages http://www.fergys.co.uk/ View the Grimshaw Family Tree at: http://www.fergys.co.uk/Grimshaw/ For The Fergusons of N.W. England See: http://myweb.tiscali.co.uk/fergys/ _____________________________________________________________________ ---------------------------------------- > Date: Tue, 9 Jun 2009 19:29:26 -0700 > Subject: [LegacyUG] How to merge a basic source into ESM template source > using Access > From: rfvanwasshn...@gmail.com > To: LegacyUserGroup@legacyfamilytree.com > > In L7 after vers. 55 sources to be merged must have the same source > templateID, (tblSR TemplateID). Basic TemplateID = 0 and ESM source > template IDs are positive integers. Using Access we can manually > change a basic TemplateID to match that of the ESM source we want to > merge it to. > > In Legacy: Tag the 2 sources you want to be merged (1 ESM & 1 basic). > From the source list check "show only tagged sources" to verify you > have only 1 basic & 1 ESM. > Also: For the basic source: Show List> Clear all tag1> Tag everyone > in List.This will help to fill in the citation template later. From > File> Save Family File as: BasicSource > > Close Legacy. Open Access with your main file.fdb. > Add the following select query to view tagged sources: > > SELECT tblSR.IDSR, tblSR.SrcName, tblSR.Contents, tblSR.UseStandard, > tblSR.TemplateID, tblSR.SrcTag > FROM tblSR > WHERE (((tblSR.SrcTag)=1)); > > Manually make following changes on the select query: > Change “TemplateID” of the basic from 0 to equal the positive ID of the ESM. > Change “UseStandard” on the basic from 1 to 0. > Notice “Contents” of ESM record contains a template but the basic remains > blank. > > Close Access. Open Legacy. > > Your 2 tagged sources now have the same templateID so they can now be > merged or you can wait till you've filled in the source Detail > templates. > > Go through your tagged individuals to fill in citation detail > templates, untag Individuals as templates are filled in until all are > untagged. > Your multimedia will be there, Text/Comments will be there and > Recorded date also. If you can't fill in the citation detail template > from viewing multimedia or Text/Comments go back to your old > BasicSource file. > > -- > Richard Van Wasshnova > http://www.gencircles.com/users/vanwasshnova > http://gw.geneanet.org/vanwasshnova _________________________________________________________________ Get the best of MSN on your mobile http://clk.atdmt.com/UKM/go/147991039/direct/01/ Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp