I've got to build a site for a business that has multiple franchises. The business needs to supply the franchisees instructional PDF documents ranging from A, B, C, D, E, F, G, H, I, J, K, L, M, N, O, P, Q, R, S, T, U, V, W, X, Y & Z. Some franchisees get instructional documents A & B, other franchisees may get documents A,C, D S, T, U, V, while other franchisees may get instructional documents B, C, D, L, M, N, O and so on.
Uploading each franchisees' instructional PDF files to their own Multi record is not an option, because of the quantity of Instructional PDF files and the total number of franchisees, would mean hours of time spent uploading new documents repeatedly to each franchisee.
Where as if I can create a relationship between the PDF downloadable files category and the Franchise, then if and when the client needs to update an instructional PDF file, they would only need to upload the new PDF file once to effect all franchisees.
I need to create a method where I can upload a single instance of each instructional PDF document and assign the upload to the franchise that is allowed to see the instructional PDF files they should see on their franchise site page.
I've created a menu type Category in the section editors called "Instructional Documents" where I have uploaded each PDF files as a single record. Now I need to create a Multi section where I'll create records for each franchise, and use some kind of field (pulldown - multi value) to assign the instruction PDF files the franchise has access to.
The end result is I need each franchise page, to show a list of the Instructional PDF files as links to download the Instructional PDF files that are assigned to the franchise and no other PDF files that are not assigned to the franchise.
Anyone have suggestions on how to achieve this?