what is the best way to include other docs in a form.

[iowabuckmaster]

I have a pretty plain invoice tracking database. The user wants the ability to be able to attach a document (word, excel, pdf or even text files to a invoice record on a form. Database is on a shared drive, a folder for the documents can be on the same shared drive. I want user to be able to attach the file. I tried the bound and unbound object frame tools but did not work like I want. I don't want the doc to be seen, only the icon representing the doc. If you want the doc opened, then double click on it.

I want users to be able to add this icon which will represent the document. So later,when they pull up this invoice, all infomation is there, plus, the doc icons are under the Attached Documents title in the rectangle. What is the best way to go about doing this. And advise would be greatly appreciated.

 

[jimb0ne]

the best way to go about this would be to have a field which was delimited by something like ;, and have this field store all the paths to the documents which were attached. You could then build the list of documents in code when a new record was opened, and display them in the appropriate area. I suppose you would have to use some generic icons, like an RTF icon for all text documents, basically your choice. You could also then just open the path to the document when the user clicked on the icon.