How To Submit And Embed PDF -- this topic walks you through some of the details to get the "Media Link" formfield to be absolute and allow the PDF to be embedded and used by the EMBEDPDF macro.
How does this all work?
To track projects we are working on, our News Media page lists all the articles, videos, audio, etc. that has been submitted. Each project can list the articles that apply to that project. All the articles sit in a big "pile" and they can be listed in an unlimited set of reports.