I used ASPrunner.net to create a nice little website that accesses patient records. The data is on Azure, a standard SQL database. I have just started to work with BLOB storage. I created a container and put a pdf file in it.
Here is what I want to do:
I created a field in one of the tables that will hold the url address of that patient's pdf file. Right now I can see the full url but it is not a hyperlink (I do not think SQL has the ability to make a column of hyperlinks? I could be wrong. Right now the column is a simple nvarchar(max))
If I cannot make the field a hyperlink could I have a button at the top, that when the user presses it, whatever patient they are on it will grab that url and go to it?
Thanks