This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Automatic Values unique to each product no

Hi all,

Let say that I have these document class and properties.

Class Work Order
Properties

Work Order No  (text)

Product No (text)

Running No (Automatic Value, integer, increase by 1)

For running no properties, I configured it as automatic value, integer and increase by 1. However, I wanted the running no to increment if we add new document with same product no. If we add new document with different product no, the running no should start from 0.

For instance.

Document 1

Product No: 111222

Running No: 1

Document 2

Product No: 111222

Running No: 2

Document 3

Product No: 333444

Running No: 1

As you can see on the example above, the running no properties will only be incremented if we use the same product no. If we entered new product no, it will count a new running no for that product no. Does this require some scripting ? Or any ideas without scripting ?