I've got an Access Web App hosted on our company SharePoint and have created a linked list in Access to allow me to track the documents in one of the Documents Libraries there. Only problem is, I can't actually do anything useful with that Linked list, since I can't add additional fields to that list in Access and I can't pull data from it with a data macro - like I can't even copy data from it...
so um... what's the point in linked lists?!
What I'd like to do is take this Linked List (effectively a live representation of the contents of this particular document library - customer site visit reports - , which also happens to have handy hyperlinks to the docs themselves!) and match the number on the document to the visit report record in the database. That way, team members just need to upload the visit report, refresh the web page and hit a button to automatically import the hyperlink to the record, viola a connection to the pdf document right there in the List View.
If I can't do this, is there another workaround which doesn't rely on my manually importing a new unlinked list of the docs to work with?
Thanks,
N