Hi again Jay For your advanced sourcing, you could do what (I think) you want by using Microsoft Access and adapting this SQL to make an "Insert Query".
Ive used this in my file (Legacy 7.5) some time ago to locate birth and death registrations which don't have the correct source, and if the update is executed, it will add the specified source citation to those events. You will need to adapt it a little especially: I have custom events called Birth Registration and Death Registration - you will need to substitute the name of your custom event. Change the value 2660 to be the value from tblSR that corresponds to the source you want to cite. Take out the references to England and Wales, and add your tag selection The other values suited me as I never use them, but you could cite a source manually for an event in Legacy and see what values were put in tblSX (event source citations), then modify to use them. You will need to look at tblER to locate the specific event for the specific person (using the IDIR field), then find teh entry in tblSX which has the matching IDIME number to your event. If you simply click the grid button (datasheet view) it will show you what its selected wiuthout updating. But if you execute the update (its the ! button in Access2000) it will update your file so you definitely need to check it on a test copy and make sure it does what you want as theres no going back except to restore from backup. INSERT INTO tblSX ( IDIME, IDSR, Type, SrcSurety, SrcPrint, SrcPrintDetail, SrcPrintText, SrcPrintNote, EnteredSD, [Order], Used, Verified, FilingRef ) SELECT tblER.IDER AS IDIME, 2660 AS IDSR, 30 AS Type, 3 AS SrcSurety, 1 AS SrcPrint, 0 AS SrcPrintDetail, 0 AS SrcPrintText, 0 AS SrcPrintNote, -99999999 AS EnteredSD, 0 AS [Order], 0 AS Used, 0 AS Verified, "Auto added BMD" AS FilingRef FROM tblSX RIGHT JOIN (((tblIR INNER JOIN tblER ON tblIR.IDIR = tblER.IDIR) INNER JOIN tblET ON tblER.IDET = tblET.IDET) INNER JOIN tblLR ON tblER.IDLREvent = tblLR.IDLR) ON tblSX.IDIME = tblER.IDER WHERE (((tblER.IDType)=0) AND ((tblET.EventType)="birth registration" Or (tblET.EventType)="death registration") AND ((tblLR.Location) Like "*, England" Or (tblLR.Location) Like "*, Wales") AND ((tblSX.IDSR) Is Null)) ORDER BY tblIR.IDIR, tblER.Order; No guarantees!!! -- Regards, Regards, ColinCharman 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://support.legacyfamilytree.com Follow Legacy on Facebook (http://www.facebook.com/LegacyFamilyTree) and on our blog (http://news.LegacyFamilyTree.com). To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp
