* When I sent this through nabble, it went to spam in my outlook so re-sending this from my gmail:
Hello listers, We have users complaining about missing attachments all the time. Now, users have certain attachment which have unique names as they append time-stamp with attachment name. We found that 1) Few attachments are not on 'AR System Email Attachment' form at all. 2) Few attachments are on 'AR System email Attachment' form but there is no corresponding record on 'AR System Email Association" form. 3) Few attachment even have corresponding records on 'AR System Email Association' form where DestinationID field matches the UniqueID of 'AR System Email Attachment' form but the SourceID field (which should be Unique Identifier field on 'AR System Email Messages' form) has no match on 'AR System Email Messages' form. How does that happen? Obviously ALL EMAIL ATTACHMENTS should have a corresponding record on 'AR System Email Association' field. Case # 3 describes that there are attachments, there is even an association record but there isn't a matching email!! Now, users CAN see these emails (may be different Unique Identifier) but they can't see the attachment as there's a mismatch in association form!! Any help would be GREATLY appreciated!! Thanks, Dave. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"