Just beginning to delve into SQL syntax in VFP and would like to create a primary (numeric) key in a table. I would also like this field to simply be an integer value which increments by 1 each time a new record is added.

Some SQL languages have a definition which causes this to happen. I haven't seen any reference to something like this so far. Is there anything like this in VFP ?

If not, is there a recommended method for handling this ? Separate FREE table to store next value in ? Table within the database ?