>>Hello,
>>
>>We are using Visual FoxPro 5.0 and we are building a framework. For our tables we want to use a primary key on an 'integer'-field. Is it possible to increase the integer automaticly every time we add a new record so we will get a surrogate primary key?
>>
>
>It's standard way: you have separate table 'setup.dbf' to store tablename and next available keyvalue. When application requests new key, it goes to this table, locates appropriate table name, locks this record, picks up the leyvalue, increments it, unlocks the record and returns keyvalue.

Do you know if it is possible in Visual FoxPro 6.0 to create a surrogate primary key automaticly (autonumbering), so that there is no need to use an extra table to see what the latest number is?

Greetings,

Afier Appelman