Hi Tom:

As Eric said, VFP 8.0 has an Auto Increment field type that you can use.  
However, a word of warning:  The VFP ODBC driver cannot read a table with
an auto increment field.  I don't know if this is important to you or not.  
If you need to read the table from another application, that application
would need to use the VFP OLE DB Provider.

I hope this helps.

This posting is provided "AS IS" with no warranties, and confers no rights.

Sincerely,
Microsoft FoxPro Technical Support
Lee Mitchell

*-- VFP8 HAS ARRIVED!! --*
Read about all the new features of VFP8 here:
  http://www.universalthread.com/VisualFoxPro/News/VFP8Release.asp
Purchase VFP8 here:
  http://shop.microsoft.com/Referral/Productinfo.asp?siteID=11518

Keep an eye on the product lifecycle for Visual FoxPro here:
http://support.microsoft.com/default.aspx?id=fh;[ln];lifeprodv
  - VFP5 Mainstream Support retired June 30th, 2003
  - VFP6 Mainstream Support retires Sept. 30th, 2003

column,