Recently, I asked Dennis Kowallek about this very issue. This is his response which works great. You'll need Ltools Deluxe. Just this one feature will more than pay for the purchase and then there's many more. --------------------------------- I received the following question this morning...
>This morning I was pondering about a method to find all cousins who >married. [snip] >Hope you are intrigued. This is something that our family association >reports in their newsletter when citing obituaries, marriages, births, >etc. A typical reference to a child born from one of these marriages might >read "He was a double Taylor descendant" and then it would list both of his >lineages back to the common ancestor. We have a few people that have been >reported as "Quintuple Taylors" where they descend from Joseph Taylor/Sarah >Best five different ways. Anyway, I hope you might at least comment about >a script possibility. Thanks. *** The first thing I thought of is that the solution would be fairly simple *if* I could find a way to tag *only* the blood descendants of an individual. However, I could not find a way to do this in Legacy, and LTools doesn't have this feature. Legacy's Advanced Tagging lets you tag descendants, but it also tags the spouses of those descendants, which is not what I wanted. After giving it some more thought, I came up with a nifty trick. LTools "Set Special User IDs" can be used to "tag" a descendant line sans spouses using the UserID field. I entered the "Starting RIN" for the common ancestor and selected "Fill descendant's User ID with Text + Henry number" and set the "Text" field to "TAG". After running the LTool, all UserIDs looked like "TAGxxxxxxx". Then I ran the following query in "View Legacy Tables"... SELECT tblMR.IDMR FROM tblIR AS Wife INNER JOIN (tblIR AS Husband INNER JOIN tblMR ON Husband.IDIR = tblMR.IDIRHusb) ON Wife.IDIR = tblMR.IDIRWife WHERE ((Husband.UserRef Like "TAG*") AND (Wife.UserRef Like "TAG*")) This query gave me a list of the MRINs of married cousins. You can add more info to the output or transform this SELECT query into an UPDATE query to set a Marriage Tag if you like. -- Dennis Kowallek (LTools/Custom Programming) [email protected] http://zippersoftware.com/ltools/index.htm http://groups.yahoo.com/group/ltools 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 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
