I am using VFP 8 to develop an application with the data in MS SQL 2000.

I have a table with an identity field called ID and it is an integer. When I append a blank record, I thought it would populate the ID field with the next number but it does not.

Now I just go to the bottom of the table and add one to the last record ID, but this could get darn slow as the system ends up with a large number of records.

How do I get SQL or VFP to automatically increment that number?

Should I just not use Append Blank?