Hoo boy. Start here: How to achieve Unique, Sequential Numbers Reliably? - #57 by morgan… and READ THIS ENTIRE THREAD.