Hyperlink - more than one

[mcraven]

Hello,

I created a button on my form for the user to click, take him to a common directory, and double click on a document. The doc is stored in a field on the form (hyperlink). I need the user to be able to attach more than one document, if that's the case. When I create another hyperlink field so they could store a second document, the document they pick first stores in both hyperlink fields. HELP.

 

[boblarson]

Your table design is incorrect then. You need a table for documents selected with a foreign key set to the id number of the record they are associated with. Then, you would use a subform to assign multiple documents to a particular record.