>The UT Article "The Easy Way to Form a Primary Key "
>
>
http://www.geocities.com/vhpcg/primkey.html>
>Looks like a great solution for generating primary keys.
>
>It does away with the need for a seperate key table and it needs no parameters to work correctly.
>
>It also looks like it solves the problem of the wrong keytable being used if you are working with 2 databases open
>
>I am considering adopting this code for some of my DBCs.
>
>I would like to know if folks have been using it happily, or can anyone spot any problems in the code.
>
>Many Thanks
There're at least two problems with this code. First, in order for it to work you've to keep file lock until you saved your data wich code doesn't do. If it did, it would create lock contention. Second, the last phisical record in the table not neccesary the record with the highest key.
--sb--