Jenny, I believe you are thinking of Basic to SR. This was to convert SR back to basic. I don't think anything is lost going this way, just condensed.
-- Richard Van Wasshnova On Wed, Nov 24, 2010 at 1:50 AM, Jenny M Benson <ge...@cedarbank.me.uk> wrote: > >> SELECT tblSR.IDSR, tblSR.SrcName, tblSR.Contents, tblSR.UseStandard, >> tblSR.TemplateID, tblSR.SrcTag, tblSX.IDIME, tblSX.Type, >> tblSX.SrcDetail, tblSX.SrcDetText, tblSX.SrcDetNote, tblSX.Content >> FROM tblSR INNER JOIN tblSX ON tblSR.IDSR = tblSX.IDSR >> WHERE (((tblSR.SrcTag)=1)); >> >> This will show you all the citations using that Master Source. >> Under UseStandard, change the first record from zero (0) to one (1). >> The rest of them will change too when you move cursor down to next >> record. >> Under TemplateID, change the number there to zero (0). The rest of >> them will change too when you move cursor down to next record. > > I use this method to convert all my Basic Sources, but BE WARNED! Not > all the Source Detail is retained - or perhaps it is more accurate to > say that not all Source Detail fields will be populated so it is > necessary to visit each citation to add any missing information. > > Still a whole heap better than doing the entire operation manually, though! > > -- > Jenny M Benson > > 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/legacyusergr...@legacyfamilytree.com/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp