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.