SQL Server does not have any concept of a record number. You will have to create one either programmatically or delcarative (using an IDENTITY column).
You best bet would be to change your data access routines to carry the Primay Key instead of a record number.
-Mike