I have an app I use for setting up system access for new employees that has several tables relating to employee records. There is a table of Documents that are templates to be used when creating records in other tables. I want to have a button when I am creating a new record in my Requests table that will pull up the specified template from my Documents table. The document would be the same one for all records on the table.
I have tried to make a file attachment field type, but that only lets me upload a new document with the record. And I was also looking at a formula URL field and have been tinkering with different ways to set up a table relationship, but have not been able to figure this out.