On Fri, 23 Jul 2010 15:27:05 -0400, "Russ McGillivray" <[email protected]> wrote:
>This is probably a question for Dennis - > >All the discussion about how to get source detail pictures into web pages >reminded me that I have hundreds of document jpgs linked to Source Details >that will never see the light of day unless I do something about it. > >Is there some code one could write in SQL that would > >1. Select all Source Details with a picture >2. Find all of the Events that reference that source detail record Just events that appear in an individual's Events/Fact list? What about marriage events/facts? What about the master events like Birth, Baptism, Death, Burial, Marriage? >3. Copy the picture name to the Event Detail records Copy it? Or replace it? Replacing the pointer from the image to the source detail with a pointer from the image to the event would be much simpler and probably doable with a single UPDATE query. >This way the pictures will be accessible for web pages without the need for >any HTML coding. > >I tried working my way in Access through the tables with no success. -- Dennis Kowallek (LTools) http://zippersoftware.com/ltools 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 To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp
