> 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
