Building a document storage system, using remote secure containers...and trying to save a bit of space...
Many documents are discontinued, obseleted, or otherwise "not there and not supposed to be there" for various reasons.
One way to handle this is to put an overlay field over the active pdf container that says "Obselete" or some such...
Another way would be to store one pdf saying "This document was intentionally removed".
Using option 2, it would be nice to have 500 records reference on pdf rather than to store the same pdf 500 times.
Is this possible?
Everything else seems to be possible in FMP...who's got the great idea this time?
You could have a child table of PDFs and related each record in the parent table to the PDF.