C.G. Here's a simple SQL that will list picture files for each RIN. The script could easily be converted to an update to set a tag. The IDType < 20 are multimedia linked to the tblIR and PicType=0 are photos.
SELECT tblBR.IDBR, tblIR.IDIR, tblIR.Surname, tblIR.GivenName, tblBR.IDType, tblBR.PicType, tblBR.PicName, tblBP.PicPath FROM (tblBR INNER JOIN tblIR ON tblBR.IDIR = tblIR.IDIR) INNER JOIN tblBP ON tblBR.IDBPPic = tblBP.IDBP WHERE (((tblBR.IDType)<20) AND ((tblBR.PicType)=0)); Ron Taylor On , Ron Taylor <[email protected]> wrote: Ltools can show a list of all attached multimedia. Run the option "Find unattached multimedia" and then uncheck the box "Only display multimedia files that are unattached". You could also check out "Photo List Options" in the Legacy help file. Ron Taylor On Monday, March 31, 2014 3:56 PM, C.G. Ouimet <[email protected]> wrote: No ideas? ------------------------------ I must be missing something ! I’m trying to tag all individuals/marriages with media files attached but that seems to be the only thing we can’t create a search list for. Am I missing something? C.G. Ouimet Kingston ON 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 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 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
