There is a Master Copy and the Master Copy has a multi select with the master SOP names.
I have a document storage app which has a table named Manuals and a table named Supporting Documents. Each has a File Attachment field of the same name. Each Manual has multiple Supporting Documents. This is handled by a standard one to many relationship.
I found out today that each Supporting Document could potentially ‘support’ multiple Manuals. This could be handled by simply uploading the Supporting Document file multiple times, each record being related to a different Manual. Due to storage space and modifications of files I do not want multiple Supporting Document records that contain the same file attachment.
I tried to use a multi-select field in the Supporting Documents table that would check off the multiple Manuals, and through a report link field link the Supporting Document to the Manual records. This won’t work because there are over 250 Manual records, and the Multi-select can only handle 100 values and 20 selections. Otherwise it would have worked.
I could create a regular text field and manually type in the names of the Manuals that the Supporting Document supports, but I don’t want to do that either.What’s the cleanest way to get one Supporting Document to be able to be related to multiple Manuals?