That's exactly what I needed.

Thanks, Borislav

Jim

>>What's the syntax to alter a field to be AutoInc? I tried the following, but it doesn't work:
>>
>>

	Alter Table (DBF()) Alter Column LicenseTag FieldType AutoInc NextValue (lnNextValue)

>>Thanks
>
>The field must be INTEGER ONLY!
>

>Alter Table (DBF()) Alter Column LicenseTag I AutoInc NextValue (lnNextValue)

>
>Also current table must be opened exclusive.