Link to home
Start Free TrialLog in
Avatar of janice12345
janice12345

asked on

Access - Link to external file

Hello,

I have a client table (client) and a document table (document). They are linked 1:m.

I want a user to use a form (called: client) with a subform (called: document) to enter a hyperlink into a record on the subform. The hyperlink will point to a document in an external folder.

The user will scan a document in, call up a customer record via the form named client and insert the hyperlink into the subform.  Once linked a user will be able to call up a customer record and click the link in the subform to launch the document into an external application (.doc . pdf .xls etc)

Thank you for any help assistance.
ASKER CERTIFIED SOLUTION
Avatar of Scott McDaniel (EE MVE )
Scott McDaniel (EE MVE )
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of janice12345
janice12345

ASKER

Work really well. Very pleased.  Thank you. jan.