Hey Nadya,

I can think of a good reason: If you have a sequential ID number that's "visible" and not the primary key, which may be managed internally and never viewed.

>
>Just curios: what is the situation, where you need two auto-increment fields in one table?
>
>>I need an auto increment function like the ones includes with MM for the primary key NewID() for another field.
>>
>>Is it possible to use the NewID() function to auto increment a field other than the primary key?
>>
>>I just tried unsuccessfully by adding an entry into the ID.dbf table, but NewID checks the “Database” property through CursorGetProp and it crashes even if I add a “dummy” table with the same entry into ID.dbf
>>
>>I’ll create another function to auto increment fields, but I’d like to hear the advisse from other MM users.
>>
>>Thanks in advance and regards
>>
>>Oscar Corte