I have a DB which is live and an archive DB. I have created an agent called 'Archive' which runs through selected documents in view, copies them to the archive database and then removes them from the live db.
No probs so far.
But, each doc in the live DB has a unique reference number (say an invoice number). The live DB will not allow any 2 documents to have the same invoice number.
HOWEVER, when documents are archived, they no longer exist in the live DB and it will allow users to 'duplicate' reference numbers despite them existing in the archive DB
Question is this... how do I get the document save validation to check not only the documents in the current database for unique ref nums, but also to include the ref nums in the archive DB?