Auto number field in AutoIndex

A file cabinet for data records only has an Autonumber field that is updated correctly when a new record is created using the Store Dialog.

An AutoIndex job also runs on this file cabinet with the "create new record if no match" option enabled. New records are created but the Autonumber field is left empty.

This makes sense as the number group is specified in the store dialog. But the user requires Autonumbering for all records. 

Does anyone have a suggestion or way around this?

Hi Steve,&nbsp;<br> <br> how about a simple workflow which uses only an assign data step?<br> You can retrieve the currently highest number in the file cabinet, increment it by one and write it into the index field.<br> However, if you do it this way, the workflow should be the only thing writing into this number field, meaning you need to disable automatic numbering in the store dialog and instead let the workflow handle this.<br> <br> Hope this helps.&nbsp;<br> <br> Greetings from Germany,&nbsp;<br> Simon H. Hellmann<br> DocuWare System Consultant

Simon, thank you for that info. Can you suggest the syntax for finding the highest number currently in the file cabinet? I tried this as a where clause; DW_Auto_Number = MAX(DW_Auto_Number) but the workflow faulted as the MAX function is not available.

Thanks again, any clues appreciated.

Hi Steve,&nbsp;<br> <br> I think you need to use "File Cabinet" instead of arithmetic expression.<br> There, you might be able to use the SQL Statement to find the highest current value.<br> However, I never tried to set something like this up, so I can not give any details about how or even if that works, that was just my first idea.<br> If "File Cabinet" does not work, maybe you can set up an extra view on the database server which provides the needed information which you can access also from workflow designer.<br> <br> Greetings from Germany,&nbsp;<br> Simon H. Hellmann<br> DocuWare System Consultant