I need to build a list in SharePoint that auto assigns a sequential number and can associate that auto assigned sequential number to a "smart number" based on the company code.
For Example: ABC company uses smart numbers 23xxx. XYZ company uses smart numbers 567xxx. I need a sequential number that is not specific to company, say 89xxx.
So, we hire someone at ABC company and they need a sequential number 89001 and a smart number 23015. And we hire someone at XYZ the same day, so need a sequential number 89002, and smart number 567456.
Is it possible to have multiple lists generating numbers and somehow tie them together, based on company? Thoughts on this?