I have a master project datasheet where each row represents a project. I have built various reports for vendors involved to make sure the appropriate vendor only sees the appropriate rows and data fields. Each row has multiple vendors involved.
I would like to add similar control for attachments, but ensure only the appropriate attachments are shared in each vendors reports (Confidentiality among Competitor concerns).
The two thoughts I have had to do this are:
a. Load the attachment to a field vs the row. But there doesn't appear to be an attachment field option. And control visibility by access to the distinct attachment fields in reports.
b. Create different data sheets with a common join key field. In trying this I have built secondary vendor sheets with the join key for the attachment. If I create a report with both data sheets its a Union not Join function and then creates duplicate rows for each project. So I tried using join/collect function to pull the values from a master sheet. However this only allows each report to only see attachments of one sheet. There are many cases where Id like to share attachments across multiple sheets.
Is there a way to do what I am attempting?
Dave
