>Of course, if you are using the value for a primary key, you may want to consider using the UniqueIdentifier data type and GUID values... this eliminates the need to go to the back end for every id.
Bob,
I'm planning to do so ; let generate the PK by the backend, but the users key (for example invoicenumber which needs to restart every year) by this mechanism. I was wondering if it was possible to change the autonumbering that SQL7 does, programmatically ; I mean ; could I use this autonumbering for my invoicenumbering also and let it restart at 1 from VFP whenever I want ?