Background: On a home-study school's server, there is a folder for each student. Within each student's folder are 5 other folders which contain documents for communications, other documents, complaints, financial and general pdfs and Word docx files.
Solution: I have created a database that captures the name of each student's folder, the name of the 5 other folders and the document names of the contents of each folder. The contents are collected as a return-separated list within 5 text fields.
Problem: I would like the user to be able to click on one of the document names and have the system open that document. If I can get the position of the cursor within the text field, I think I can get the contents of that list row, then build the full path to the document and open it. I think I have seen this done somewhere, but I don't remember where. Can someone point me in the right direction.