Including more than 1 file links

[sunnyday]

Hi ,
I have a reference field which users can copy paste the file reference link and it takes it to the relevant intranet site doc
I am wondering how is it possible to copy paste more than 1 link in that field as users might have more than 1 document be it be word pdf or excel.
How can one do that. Is there any keyboard shortcut or something that i have to enable in the design view? making easy for users to copy paste and then enter a comma and then copy paste again or manually write in the url name or link.

eg: File reference www.hvhhb.xlsm, url:gfgf:hjh/jhjh/gbxx.pdf, url:ghghg.ggxhg.doc
Many thanks

[CJ_London]

You need to store these is a separate, linked table eg.

tblMain
MainPK autonumber
MainName text
....


tblLinks
LinkPK autonumber
MainFK long (links back to MainPK)
FileShortcut text (put your links here)

[sunnyday]

Hi,
Well my databse has already been developed. And there is a hyperlink field in the main form . What I wanted to know that is it possible to put in more than one hyperlinks in the same cell. Although we can copy paste the links seperated by a semi colon; the cell when clicked opens up only one link. When generating reports I want that the user has the ability to insert more than one hyperlinks such that when reports are generated one can click on each provided link seperately.
The database has already been split and distributed so I do not want again to create a seperate table and link again to main table. That hyperlink field is a part of the main form and has to be in the same main form.

Thanks

[CJ_London]

the cell when clicked opens up only one link

So far as I am aware, this is the only way it works.

That hyperlink field is a part of the main form and has to be in the same main form.

you would use a subform on the main form

good luck with your project