Posted Fri, 17 Jul 2020 20:11:27 GMT by Edward Clarke Community Service Partners Director of Information Technology
I have created a file cabinet and I want to know if I can make the "Vendor" and "Invoice #" unique together.  Example, company "ABC" has an invoice "123" and I want to make sure that invoice number can't be used again for that vendor.  But if company was "DEF" and invoice number "123" that can be entered as it is different by vendor name.

I am on DocuWare 7.2.
Posted Tue, 21 Jul 2020 08:07:03 GMT by Simon H. Hellmann Toshiba Tec Germany Imaging Systems GmbH IT-Consultant Document Management Solutions
Hi Edward, 

this is not possible with unique fields. However, you could put all the stored vendor documents into a workflow. The workflow can then check if this specific combination of index fields already exists in the database.
If it does, the status could be changed to "duplicate" or something like this so you can easily search for this or display them in a task list to review. 

Hope this helps. 

Greetings from Germany,
Simon H. Hellmann
DocuWare System Consultant

You must be signed in to post in this forum.