I am trying to create a form to simplify uploading files to a “Lookup” style attachments field.
The table we work out of (Table W) consists mostly of lookup fields pulled from another table (Table S), including the attachments field in question. Multiple records are generated on Table W from Table S and we do not want to upload project files separately to every single related record on Table W.
The primary field on Table S is a formula field derived from entries within that record. There are no other unique fields that can be used in a form to select a specific record to allow an upload to the desired field.
Any ideas on how to make this work? I can’t show any examples of the tables, but I can try to fill in anything I may have missed in my description.
This is where I am stuck, we have a few users who are unable to navigate through the linked fields to add the files to the correct place. Asking these users to switch to Table S and then find the correct field for upload may be equally fruitless.
My only other option would be to create a view with only 2 visible fields.