I have a table set up with a hyperlink field. The function is to be that the hyperlink allows the user to open a .pdf scan of the document for more information (otherwise, to add the extra info, the table would have at LEAST 40 more columns than the 15 it currently has).
I understand that in order for the hyperlink to work the files have to be in a folder within the database, which is in process (40 scans down, 3965 to go).
Questions:
How do I add the URL to the column?
And what would be the best way for the user, my boss, to assess the hyperlink? - I was thinking a button on a form that would open the .pdf in another window. However, from what I've read on the internet, it seems beyond my current capabilities, as it involves a lot of code; and in the scheme (or schema) of things; I'm not sure in the list of coding text, of where I am to place additional text).
Thank you for any assistance, and now, back to scanning...