Re: [LegacyUG] How to merge a basic source into ESM template source using Access

[Elizabeth]

Although I have both Access and OO database, I have no experience of
using either programme - it simply hasn't proved relevant to my
computer needs.  Is it possible that this method of combining sources
will be available in Legacy at any time?

-- 
- - - - - - -
Elizabeth
researching ALLAMBRIDGE (Dorset, Somerset and anywhere else they might turn up)


2009/6/10 Jim Terry/Support <jimte...@legacyfamilytree.com>:
> Richard,
>
> This is a jewel. I tried it out and it works great!
> Thank you for choosing Legacy,
> Jim Terry
> Technical Support
> Legacy Family Tree

> -----Original Message-----
>
> From: k...@legacyfamilytree.com [mailto:k...@legacyfamilytree.com] On Behalf
> Of Richard Van Wasshnova
>
> Sent: Tuesday, June 09, 2009 7:29 PM
>
> To: LegacyUserGroup@legacyfamilytree.com
>
> Subject: [LegacyUG] How to merge a basic source into ESM template source
> using Access
>
> 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
>



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