>Cetin,
>I agree that all database programmers use the concept of the primary key. However, in FoxPro if there was a problem with the 'primary key' it did not shut the application down and the programmer would usually be able to sort things out. In VFP screens using a table with a primary key will not open if the key has been violated. Granted, I have not always been intelligent in handling primary keys - handling deleted records has caused me nightmares, but it would have been nice if VFP had included a primary key generator and if the code were a little more forgiving in handling primary key violations. Just mouthing off....

Strongly agree VFP could and should have a auto key generator. If PK errors too irritating you could set your index to be regular but check with your own way that it's always unique :)
Cetin