>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
Thanks Mike;
We do carry the key but what we are trying to do is allow the user to see a 10 character number field - Actually a journal # so they can record it as a reference.
With an identity column they get the id afterwards and with Foxpro I would have to requery the table after each save to get the new value for the identity column.
Thanks Again
Shawn