I am working with an database that someone else designed but I have since taken over. I am tasked with updating a "Document" Tab on the existing form. This form currently consists of a dropdown list of "Product" names. I have added an attachment button that shows the number of files attached. The customer also would like to see the attachment file names. I have included a sub-form which shows the file names but it also causes the drop list to duplicate the "Product" names (ie. 3 attachments for Product - AMT1 will cause AMT1 to appear in the dropdown list 3 times).
Is there a fix for this or is there another way I need to approach this customer request.
Thank you
Lisa