MattMelrose
5 years agoQrew Member
link to file based of related field in parent table
Hello,
I have two tables
Project and Documents
Project has a bunch of internal information and the documents are supplied by client / staff
Each document has a specific type and related to the project via the job number, all associated files relate correctly in a table report, but it is a lot of steps for the staff using mobile devices.
What I am looking to do is basically have a URL field that will look at the related project files and the type of the file and provide a hyperlink for easy download / viewing. I have made a hyperlink inside of the child table that opens the correct file, but when i try to lookup that field on the parent it doesn't populate.
EG.
Projects tab
Project number - 12345
Documents tab - Document report:
Related Project Type Name URL
12345 Plan file1 working link
12345 Photo image1 working link
I would like to be able to move that "working link" for the most recent project (in this circumstance it will be the only plan associated at this time to the project) to the main project page.
Thanks for any help
------------------------------
Matt Melrose
------------------------------
I have two tables
Project and Documents
Project has a bunch of internal information and the documents are supplied by client / staff
Each document has a specific type and related to the project via the job number, all associated files relate correctly in a table report, but it is a lot of steps for the staff using mobile devices.
What I am looking to do is basically have a URL field that will look at the related project files and the type of the file and provide a hyperlink for easy download / viewing. I have made a hyperlink inside of the child table that opens the correct file, but when i try to lookup that field on the parent it doesn't populate.
EG.
Projects tab
Project number - 12345
Documents tab - Document report:
Related Project Type Name URL
12345 Plan file1 working link
12345 Photo image1 working link
I would like to be able to move that "working link" for the most recent project (in this circumstance it will be the only plan associated at this time to the project) to the main project page.
Thanks for any help
------------------------------
Matt Melrose
------------------------------