One of the biggest challenges Nardus Swanevelder faced when he moved his application from a Topspeed database to a MS SQL Database was the autonumbering of a key. In a Topspeed database you don't even think about auto-numbering because everything happens automatically. The auto-numbering on a MS SQL table, if configured, is automatic as well but to get the auto number back into your code is a mission. But not anymore! Check out this autonumbering template that uses Clarion 10's new support for SCOPE_IDENTITY.