So I have never used the attachments field and my boss wanted it added and I didn't realize what kind of problems it would cause (like not even being able to export to excel)
My updated plan is to create a linked table that will allow me to create multiple entries for each file and use a hyperlink to point to the file on the file share.
My two questions are:
1. what is the best way to hand attachments
2. is there a way to get a list in datasheet form that will show me all the attached files so that I can then create hyperlinks from them.
Thanks for any help, still learning.