On Fri, 23 Jul 2010 16:30:05 -0400, "Russ McGillivray" <[email protected]> wrote:
>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. PICTURE <<-----> CITATION <<-----> EVENT An event can have many citations, and a citation can have many pictures. So the picture points to the citation (amongst other things) and the citation points to the event (amongst other things). >Simple update query - can you sketch the main elements? I couldn't find my way >through the different ID numbers involved. It all depends on the answer to the event types question. Perhaps a better place for this discussion would be at http://tech.groups.yahoo.com/group/ltools/. I don't want to bore people here. -- 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
