At our company we have used, in the past, an Excel spreadsheet to log and track drawing numbers. We have looked at PDM's auto number generation but are reluctant to shift to this for many reasons.
Has anyone run across a simple to use auto number generation tool that supplies the next number and asks you for a few specific details about what you are pulling the pnumber for, e.g. Description, when # pulled, who requested #, what project the # will be used for, etc.... Obviously it would be nice to search to verify the description does not match something already with a number but I would be happy with a simple sequential non-inteligent numbering tool.
Our current issues with Excel are obvious, users need read write access and then they resort the columns and save it and the next individual pulls a number or the next 300 people pull a # and then someone mentions the order is messed up.
Any direction would be appriciated. I just don't want to write an application if one exists already.
