This makes it clearer why Access and Open Office were mentioned. Thanks. On Wed, Nov 24, 2010 at 3:50 AM, Jenny M Benson <[email protected]> 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/[email protected]/ > > Archived messages from old mail server - before Nov. 21 2009: > > http://www.mail-archive.com/[email protected]/ > > Online technical support: http://www.LegacyFamilyTree.com/Help.asp > > To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp > > > >
Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages after Nov. 21 2009: http://www.mail-archive.com/[email protected]/ Archived messages from old mail server - before Nov. 21 2009: http://www.mail-archive.com/[email protected]/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp
