Hyperlink field

[Ray]

I have a field of hyperlink data type in a form. In that field, I use
Insert Hyperlink to place the file path of file in the field. I would like
to place the linked files under the backend database so I can move the
backend database together with the files. Can someone advise me how to
accomplish it. In addition, in the hyperlink field, it shows the full path
of the file. How can I change it to a label "Click here to open the
record"?

Thanks,

Ray

 

[Allen Browne]

This is awkward, in that you are relying on the user to always insert a
relative link, not an absolute link.

Personally, I just use a Text type field. You can make it look and behave
like a hyperlink (in combination with the folder name), but you can easily
parse out the file from the local/network path, and you are then guaranteed
that the file name works with whatever the path happens to be in future.