Auto Numbering unique inventory items by department?
As we enter new items into our inventory database we would like it to automatically increase the inventory by 1. We have several departments and each number should increment based on the department n...
Thank you for the KISS answer but sadly we would like to keep the numbers sequential within each department. I was looking at lookup but not sure how to set it up. Can you provide an example?