Linking Table through Hyperlink or should I use Text

[oemar00]

Hello,
I want to link tables to a document repository which can be done easily through hyperlink where Users can click the file names from the Forms, edit then save it.

The problem comes when I want to link between tables because Access says it cannot maintain and utilized hyperlink the same like type text in relationship between Primary Key to Foreign Key in tables.

The link will work by changing field type to Text however the User cannot easily click to edit and modify the document as easy as I want; that is without coding.
Is there an easy solution without going into too much of coding or VBA.

I am sure other people has solved this issue before me. I am using Access 2010 on Windows 7 Enterprise 32 bit.



Thank you.

[pbaldy]

I personally use text, but I don't think I've ever tried to create a relationship on this type of field (I'd wonder why). In any case, the code is simple:

Application.FollowHyperlink Me.txtAttachment

where txtAttachment is the name of the textbox containing the path.

[oemar00]

I personally use text, but I don't think I've ever tried to create a relationship on this type of field (I'd wonder why). In any case, the code is simple:

Application.FollowHyperlink Me.txtAttachment

where txtAttachment is the name of the textbox containing the path.

Great! This work just fine, simple and easy.

[pbaldy]

Happy to help!