Re:So in the intermediary table, am I creating a record for each Manual to Document or Document to Manual instance?
Answer: yes.
Re:
How does this control only needing to upload a Supporting Doc File Attachment one time?
Think of a more traditional situation. I like to use an Order. Imagine a table of Orders and a Table of Master Items. The order have lines items on them because an order may have several items on the order, each with a price and qty.
The line items on an order will be order lines, but really they are Order Item Assignments, because obviously 1 order has many order lines and obviously you don't sell an master file part # ABC just once, you hope to sell it many times on many orders.
But if something changes on the item master like a file attachment for an image or the selling price, you just maintain it once in the item master. You don't have to change it on all the order lines.
So same with you - the supporting document is only maintained once.
btw, once you get that working, you will then be asking me how to make a link so the user can click on a link on the middle join table to see the supporting document. I will post that soon.
