Re: [LegacyUG] HELP! duplicate multimedias

2007-06-16 Thread Richard Van Wasshnova
I've already posted the 2 delete querys. If anyone would like to see a small Legacy file which exemplfies Lisa's and my duplicate problem email me "richdi(dot)vanwasshnova(at)verizon(dot)net". Do not send to the list. Tempzip is a married couple, 79KB and tempMM.zip, (318KB) is it's multimedia w

RE: [LegacyUG] HELP! duplicate multimedias

2007-06-16 Thread Sherry/Support
Please - do not send your requests for this query to the list! Richard, please post the email address that you'd like the users to send their request to! Thanks for using Legacy. Sherry Customer Support Millennia Corporation [EMAIL PROTECTED] http://www.LegacyFamilyTree.com We are changing th

Re: [LegacyUG] HELP! duplicate multimedias

2007-06-16 Thread Richard Van Wasshnova
It looks to me that Dennis Kowallek has written a perfect delete query for Lisa based on my earlier, imperfect, explanation of the problem. Lisa, you will have to confirm but I tested it on a database in which, I believe, I simulated your problem. DELETE * FROM tblBR WHERE tblBR.IDBR in (SELEC

Re: [LegacyUG] HELP! duplicate multimedias

2007-06-16 Thread ronald ferguson
Cathy, I don't think we did but as soon as my head hit the pillow I saw saw what you were getting at. I musr confess that I am rather horrified that Legacy would allow such a thing to happen on merging without one giving explicit consent for the duplication - or does it? I cannot recollect hav