Dennis, Event types - I guess I was thinking of any event type that is linked to a picture now through the Source Detail. BMD's are of particular interest because the documents are often interesting to look at.
Copy vs. Replace: I was thinking the pointer worked the other way, from the source detail to the picture, so you raise a good question. Copy would allow one to still access the picture in Legacy through the Source, but Replace gives the main benefit. So long as there is a 1:1 relationship, i.e. if 5 individuals have the same census source detail, then there are already 5 records in the multimedia table that can be updated. Simple update query - can you sketch the main elements? I couldn't find my way through the different ID numbers involved. Russ -----Original Message----- From: Dennis M. Kowallek [mailto:[email protected]] Sent: July 23, 2010 4:03 PM To: [email protected] Subject: Re: [LegacyUG] How to copy multimedia links from Source Detail to Events 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 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
