Access Record Attachments Creating Multiple Instances of the Same Record (1 Viewer)

nonakag

Member
Local time
Yesterday, 15:27
Joined
Apr 30, 2013
Messages
54
I need help in preventing the Access Record Attachment object from creating multiple instances of the same record. If I upload three PDF documents to the record attachment object, the resulting record query lists three records of the same record. The Attachment object correctly displays the numbrer "3" for the three attachments. However, when querying that record three separate instances of the same unique record are diplayed. If I delete one of the duplicate records the Attachment object cout decrements by one, and one of the attachments are deleted. Can anyone please tell me why the Attachment object does not place the three documents into one instance of the unique record? Thank you.
 

theDBguy

I’m here to help
Staff member
Local time
Yesterday, 18:27
Joined
Oct 29, 2018
Messages
16,194
Hi. Can you please post the SQL statement for your query?
 

Users who are viewing this thread

Top Bottom