Hi Jim ---

OIC. I think in that case you're going to have to create a keyvalues table in SQL Server and maintain an incremental key of 4 characters there...you can grab a value off of that table and increment it in an INSERT trigger stored procedure.


>
>We are converting an existing app (and database) from FPW 2.6 to VFP 6.0/SQL Server. There are about 250 tables, so we are trying to avoid a primary key column conversion and use the existing method. Our key column is 4 character.
>
>Our concerns are how to make sure the key column is unique, without using methods as record locking, as we do in our 2.6 app application.
>